cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Melanie
New Member

PowerApps - problem with PowerBI title and multiple filter

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-...&$filter=Answers/Entity eq 'Ginini' and Answers/Period eq '07'"

 

Thank you in advance for your answers,

3 REPLIES 3
v-jefferni
Community Support
Community Support

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.

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-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.

 

Best regards,
Community Support Team _ Jeffer Ni

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,250)