Hi all,
I'm pretty new to PowerApps but making some nice things right now. Now I want to include a PowerApps app into a PowerBI report. So far no problems;
But now I want to filter the data in the app when I click something in PowerBI. Lets say that I select 'Needs action next week' in the pie chart I only want to see the corresponding records in the App (so that means Frank and Jan).
I've been trying many things and I've found out that I have to pass the Power BI info to the app by dropping the info into the PowerApps data:
And then you have to make a change to the formula for the Items that belong to the BrowseGallery. I've tried (because I found this online) this statement: Filter(BrowseGallery1,Gallery1.Selected.Status=Status).
But this doesn't work:
So now I have some questions
SortByColumns(Search('[dbo].[Messages]'; TextSearchBox1.Text; "Client";"Client"); "Client"; If(SortDescending1; Descending; Ascending))because of filtering and sorting of columns. Is it possible to merge the answer of question 2 with this statement?
Solved! Go to Solution.
Hi @MiKeZZa - The answer you are looking for is actually described in this blog post - https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/
You would need to do the following:
Hi @MiKeZZa,
Do you want to pass data from your Power BI report to your PowerApps app?
Further, do you want to filter data within the Gallery control of your PowerApps app based on the data passed from Power BI?
Please check and see if the following article would help in your scenario:
https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/
Best regards,
Kris
Hi @v-xida-msft, thanks for your reply.
What I want is selecting something in a Power BI visual in my Power BI report and filter the data in PowerApps based on the selection in Power BI.
So I'm not trying to integrate Power BI in PowerApps (I know how to use a Power BI visual). What I actually want is what you can see here: https://www.youtube.com/watch?v=-CjGKoXem0I at 2:36.
A little kick; still looking for an answer.
Hi @MiKeZZa - The answer you are looking for is actually described in this blog post - https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/
You would need to do the following:
@v-xida-msft great share! This is exactly what i was looking for and it seems to be exactly what the OP was descriping. How is this not marked SOLVED?
User | Count |
---|---|
142 | |
141 | |
76 | |
73 | |
71 |
User | Count |
---|---|
231 | |
167 | |
74 | |
67 | |
60 |