Power Platform Community Forum Thread Details

PBIX link: https://www.dropbox.com/s/3bhks3t4x90h7sj/FlooringEstimates.pbix?dl=0

I've created the FlooringEstimates app in the PowerApps tutorial described here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-gallery

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.

Screenshots below:

Flooring Estimates landing page.PNG Flooring Estimates Alpha Selection from Table.PNG

Categories:

Building Power Apps

I came across this walkthrough (and associated 3 minute video with link therein) which facilitated getting closer to the result I wanted. Not quite perfect, but working more closely as intended now.

https://blogs.msdn.microsoft.com/charles_sterling/2018/01/05/walk-through-of-using-the-powerapps-custom-visual-in-power-bi/

I've been stairstepping my way through this, but I think the two keys were:

(a) changing OnSelect associed with the right arrows on the Summary Gallery with "Select(Parent)" & Navigate([new screen],ScreenTransition.None) and

(b) having two different Galleries, the one with the Summary Data with Items set to PoweerBIIntegration.Data and a second Gallery referenceing the first, which is set to: Filter(Portfolio_Inputs,'PowerBI Gallery'.Selected.'Asset ID'='Asset ID')

Note that in this case, the second Gallery is referencing the table in the Excel spreadsheet - in this case called "Portfolio_Inputs" - that is the source of the PowerBI data