Unanswered

Apply multiple filters to Power BI tile

(1) Share

Report

Posted on by yperez

I created a Power BI report and pinned a visual to a Dashboard which I am using in a Power Apps.
I am now trying to apply multiple filters on the TileUrl property of the Power BI tile in Power Apps.
Before doing this in Power Apps, I tested in the report URL by appending the filters shown below and it worked.
When I append the same filters to the TileUrl in PowerApps, it doesn't work, but if I do only one of the two filters at a time, then it works.
Seems I cannot get the two filters to work at a time.
&filter=ContractEntry/EffectiveDateNumber eq '20210518' and ContractEntry/IRHedgeITEMNumber eq 'OAK6055300'

Can this be done in Power Apps? If so, any suggestion on what I may be missing.
@RezaDorrani @ShaneYoung
Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

RezaDorrani 12,143 on at

Like (0)

Report

Hi @yperez

I have not tried with with multiple filters.

Check this article (may be it may help) - Updating the PowerBI Control inside a PowerApps ap... - Power Platform Community (microsoft.com)

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
yperez 14 on at

Like (0)

Report

Thanks @RezaDorrani . I will keep looking into this.

Was this reply helpful? Yes No
DWieb 4 on at

Like (0)

Report

Hi @yperez . I am running into the same problem. Have you been able to find a solution to this?

Was this reply helpful? Yes No
yperez 14 on at

Like (0)

Report

Hi @Anonymous, if I remember correctly, I couldn't pass multiple filters into a dashboard, however, I could pass it to the report. So what I ended up doing was creating a tab on the report which will only show the value I needed to display in the Power Apps, then I used the link from that page in the report and appended the corresponding formatting for adding filters as shown starting on line 3 of the screenshot.
The trick here I guess is that initially, we can only point the Tile URL to a Power BI Dashboard, however you can change the Tile URL to make it point to a page on a report instead, then add the corresponding formatting and filters as from line 3 down.
Hope this helps

Was this reply helpful? Yes No
DWieb 4 on at

Like (0)

Report

Thanks @yperez ! I have been playing around over the weekend and have the feeling that i am getting close to getting the filters (one at a time) to work in PowerApps. I'll keep on trying but would you know at first glace what could be wrong with mine?

Was this reply helpful? Yes No
WilliamFarmer 7 on at

Like (0)

Report

Hi @RezaDorrani ,

Love to watch your video's, makes live much easier in PowerApps.

You wrote " I have not tried with with multiple filters".

I've noticed that you've posted a video on which you show how to use multiple filters on a Power BI tile, however if I use that same logic in a Power BI tile in a Gallery, it will return the unfiltered data.

Any suggestions ?

Was this reply helpful? Yes No
WilliamFarmer 7 on at

Like (0)

Report

In the meantime I've solved it by concatenating the 2 values.... now it even works having a Power BI Tile in a Gallery

Was this reply helpful? Yes No
ArturCosta 2 on at

Like (0)

Report

Hi @yperez , how do you get the url parameters? my report page url format looks different to yours. Thanks!

Was this reply helpful? Yes No
yperez 14 on at

Like (1)

Report
Hi @ArturCosta , if I remember correctly, I created a tab in the PBI Report with just the visual I wanted to show in the tile. While in the report in the portal go to File > Embed report > Website. From there, you can get the URL in this format below.
https://app.powerbi.com/reportEmbed?reportId=80a93b98-7c05-4ebe-b1fc-3b52ce6f1303&autoAuth=true&ctid=78adacea-5452-4c1d-a049-11159edc6c7f

then you only need to make some additions to the url to show only the specific tab using the &pageName parameter
As far as for filters, you will then add the &$filter section as shown below. One thing you have to remember is that you will need to specify the filtered columns in the format of [table]/[fieldName]. In the example below, my first filter is on the table ContractEntry column EffectiveDateNumber, hence ContractEntry/EffectiveDateNumber.

Hope this helps.
"https://app.powerbi.com/reportEmbed?reportId=80a93b98-7c05-4ebe-b1fc-3b52ce6f1303&autoAuth=false &pageName=ReportSection70aa1ed6ac6cce4e7c27&ctid=78adacea-5452-4c1d-a049-11159edc6c7f&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLW5vcnRoLWNlbnRyYWwtYi1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldC8ifQ%3D%3D &$filter=ContractEntry/EffectiveDateNumber eq '" & Text(varEffectiveDateNumber) & "' and ContractEntry/IRHedgeITEMNumber eq '" & Text(varSelectedItem.ITEMNMBR) & "' and ContractEntry/HedgePeriod in (" & varSelectedPeriod & ") and ContractEntry/PricingMixFlag eq 'Feed'&filterPaneEnabled=false&navContentPaneEnabled=false"

1 people found this reply helpful.

Was this reply helpful? Yes No
Schwartz_Cory 184 on at

Like (0)

Report

2023 now. Still only able to filter a tile with only 1 filter. 😞
Anything new @yperez @RezaDorrani @ShaneYoung ? I am having the same exact issues that you described in your initial post. The filters work fine only when there is 1 applied. Maybe we are concatenating them wrong for the tiles? I don't know.

It works fine via the report, but the report looks uglier and harder to read in a power app when compared to the tile view. See below:
My two filters here are just the year, and the organizational unit. Pretty simple but required filters in order for the chart to make sense to the user.

Was this reply helpful? Yes No