Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 8MQ9VlQhq8YzyehHhGT2ai
Power Apps - Building Power Apps
Unanswered

Apply multiple filters to Power BI tile

Like (1) ShareShare
ReportReport
Posted on 22 May 2021 18:20:18 by 14

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.

  • synru Profile Picture
    5 on 11 Nov 2023 at 19:42:00
    Re: Apply multiple filters to Power BI tile

    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'"

     

  • mhiggins Profile Picture
    on 16 Oct 2023 at 03:02:18
    Re: Apply multiple filters to Power BI tile

    Hi William,

     

    Could you please provide an example of how you managed to do this?


    Thank you

  • MAdnanBaig Profile Picture
    2 on 07 Jun 2023 at 11:54:49
    Re: Apply multiple filters to Power BI tile

    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.

     

  • Schwartz_Cory Profile Picture
    182 on 21 Mar 2023 at 12:59:48
    Re: Apply multiple filters to Power BI tile

    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:

    Schwartz_Cory_0-1679403500183.png

    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.

  • yperez Profile Picture
    14 on 30 Aug 2022 at 12:56:32
    Re: Apply multiple filters to Power BI tile

    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"

     

  • ArturCosta Profile Picture
    2 on 30 Aug 2022 at 12:35:56
    Re: Apply multiple filters to Power BI tile

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

  • WilliamFarmer Profile Picture
    7 on 15 Oct 2021 at 12:40:39
    Re: Apply multiple filters to Power BI tile

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

     
  • WilliamFarmer Profile Picture
    7 on 08 Oct 2021 at 18:25:11
    Re: Apply multiple filters to Power BI tile

    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 ?

     
  • DWieb Profile Picture
    4 on 17 Aug 2021 at 02:15:06
    Re: Apply multiple filters to Power BI tile

    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?

    Capture.JPG

  • yperez Profile Picture
    14 on 13 Aug 2021 at 22:01:43
    Re: Apply multiple filters to Power BI tile

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,763 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started