In my powerBI, I have a simple table that shows Flooring Name, Category, and Price per SF.
I manually entered data in a different table that shows name, SF sold and date sold, and linked the two tables together by Name.
I creased a Card Visual to show Revenues, which equals SF sold * Price Per SF.
The Card visual adjusts when I click on a row of the table, just like normal PowerBI. What I'd like is for the entire screen to be integrated, such that, when I click on the PowerApps Visual, it effectively selects the row in the table, and then recalculates the Card visual accordingly. From the screenshots below, the Card shows 501k of revenues. Then when I select the table row for [Name] = "Alpha" the card recalculates to 5497. Then when I unselect [Name] in the Table, but select Alpha in PowerApps, the Card Visual resets to all rows, but I'd like it to flow through such that the card output is 5497. Is this possible?
I have figured out how to do this in reverse, where a slicer in BI can manipulate the PowerApps, but I want the PowerApps to effectively be the slicer for BI.
Yes, ideally. As I have it set up now, there's a 2-step process. When I click the related slicer in PowerBI, the PowerApp integrated filters the Summary View so that the PowerApp is filtered to only the particular selection and then I can go through the PowerApp. What I'd like is the corrollary to be true as well, such that when I click the selection in PowerBI, it selects the same as a slicer item in PowerBI so that the remaining PowerBI is filtered accordingly.