I have created a dashboard with PowerBi title, but to make it dynamique for the user I want them to filter the entity and the reporting period. Then within the "Title Url" field there I have enter the formula hereunder. The filter options are in bold.
I have try the filter option separetky it work but not together. Do you any idea to make it work ? Do there anotherway to write it ?
"https://app.powerbi.com/embed?dashboardId=6a147e99-c32f-4ba9-a44a-64af0d7f4699&tileId=1cdfbef6-6206-...&$filter=Answers/Entity eq 'Ginini' and Answers/Period eq '07'"
Thank you in advance for your answers,
Hi @Melanie ,
Do you want to filter Power Bi tile by two conditions in URL parameters?
I'm afraid currently there's no way to filter in two conditions by passing two parameters in the URL.
As you know, by passing parameter from the app, you can filter the results that appear in a Power BI tile. But there are limitations :
Thank you very for you answer I may have just find a way to bypass this limitation !
Within the PowerBi title instead of using the URL generated by powerapps I enter the embed code of the report:
1) On my report I have generated the embeded code
2) I copy pass it within the Title UrL
3) I have insert the filters (below on bold).
"https://app.powerbi.com/reportEmbed?reportId=7035760a-d1ab-4673-afc3-f01ea1d19f63&groupId=98b0d6fa-e...$filter=Answers/Entity eq '"&ListBox_Entities.Selected.Result&"' and Answers/Period eq '"&Left(Gallery_Period.Selected.Button11.Text;2)&"'"
I have to test it with other users in order to see if it worked for them as well ...
Thank you and have a nice days
Hi @Melanie ,
Have you tested your workaround? Is it working?
If your workaround works, you could accept your post as a solution for other users to reference.
Thanks a lot for your time.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.