Unanswered

PowerApps - problem with PowerBI title and multiple filter

(0) Share

Report

Posted on by Melanie

Hi All,

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-4edf-bf74-e64967ee668e&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVdFU1QtRVVST1BFLUItUFJJTUFSWS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsibW9kZXJuRW1iZWQiOmZhbHNlfX0%3d&$filter=Answers/Entity eq 'Ginini' and Answers/Period eq '07'"

Thank you in advance for your answers,

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 :

Only one filter can be applied.
Only the eq operator is supported.
Field type must be string.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Melanie 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni,

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-eaf1-42f3-a908-76bab01d57c5&autoAuth=true&ctid=52763d51-cac3-46a4-b3a3-06566ce66c80&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXdlc3QtZXVyb3BlLWItcHJpbWFyeS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldC8ifQ%3D%3D&$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
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Best regards,
Community Support Team _ Jeffer Ni