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.
I find this workaround works but just found that the navigation and filter panel disablement have to put before the filter query string to make it work
"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
&filterPaneEnabled=false&navContentPaneEnabled=false&$filter=ContractEntry/EffectiveDateNumber eq '" & Text(varEffectiveDateNumber) & "'
and ContractEntry/IRHedgeITEMNumber eq '" & Text(varSelectedItem.ITEMNMBR) & "'
and ContractEntry/HedgePeriod in (" & varSelectedPeriod & ")
and ContractEntry/PricingMixFlag eq 'Feed'"
Hi William,
Could you please provide an example of how you managed to do this?
Thank you
Tysm @yperez ! I have got this thing working but the issue is, what to pass if want to show unfiltered data for both or either one dropdown selection? I have tried passing 'All', '' also.
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.
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"
Hi @yperez , how do you get the url parameters? my report page url format looks different to yours. Thanks!
In the meantime I've solved it by concatenating the 2 values.... now it even works having a Power BI Tile in a Gallery
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 ?
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?
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
WarrenBelz
146,763
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional