PowerApps Gallery with Power BI Table visuals

(0) Share

Report

Posted on by oappdev

901

Happy Wednesday, Power Apps Community 👍

Wanted to see, if it's possible to just show whatever row is selected from the Power BI table visuals to show up on the PowerApps gallery to the right. Right now is showing all items.

Please, let me know if I explain myself clearly.

Thank you in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @oappdev ,

Do you want to filter powerapps visual based on selected row in your powerbi table?

If so, please notice that:
"PowerBIIntegration.Data" represent the selected row in your powerbi table.

So you could use this to filter items in your powerapps visual.

Could you tell me:
whether do you want to only display the selected row in your powerapps gallery or display related rows based on the selected row in your powerapps gallery?

1)only display the selected row in your powerapps gallery

set the gallery's Items:

PowerBIIntegration.Data

2)display related rows based on the selected row in your powerapps gallery

//I filter based on Title field (Title is equal to the Title value in the selected row)

set the gallery's Items:

Filter(fruit11111,Title = First(PowerBIIntegration.Data).Title) //fruit11111 is my sharepoint list name, please replace to your table name

Results:

What's more, this link may help you a lot:
Solved: Filtering the PowerApps Visual using Power BI Slic... - Microsoft Power BI Community

Best regards,

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you @v-yutliu-msft so much! Is was I needed.

Last question,
Just wanted to know if it's possible to show "0" item in gallery into user selected row from the visual table on the left?

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report
Hi @oappdev ,

Do you want to display blank gallery if you do not choose any item in the powerbi visual?

The reason why you met that problem is that PowerBIIntegration.Data represents the first three items by default.

So to avoid this problem, I suggest you add a justification.

Try to set the gallery's Items like this:

If(!IsBlank(First(PowerBIIntegration.Data).Title),PowerBIIntegration.Data)

Best regards,

Was this reply helpful? Yes No