Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Apply different filters to a Power BI Reprt visualizations

Like (0) ShareShare
ReportReport
Posted on 22 Feb 2023 21:53:56 by

All,

 

I have a Power BI report with 3 levels of matrixes on the same page. The bottom level matrix displays data for a specific department. The next level displays the data for all of the departments in a division and the third level displays the data for all of the divisions in the company. I created a flow so reports could be sent to all of the department's heads on a weekly basis. I used filters in the ReportLevelFilters Filter section of the Export To File for Power BI Reports. This worked as expected for the bottom level, but the filters also applied to the other two levels which makes sense. Is there a way to apply the filters to each matrix? So, the bottom would be filtered for both department and division. The second level would only be filtered by the division and the third level would not be filtered so all of the data is displayed. Thank you

  • Sananya Profile Picture
    4 on 18 Jan 2024 at 06:43:40
    Re: Apply different filters to a Power BI Reprt visualizations

    Hi,

     

    I have passed the filter as mentioned above, still filters I provided on the slicer in not working.

    Even though I write manual code for multiple filters ,still its not working.

     

    Sananya_0-1705560199635.png

     

  • M_Whitenight Profile Picture
    on 20 Jun 2023 at 17:32:10
    Re: Apply different filters to a Power BI Reprt visualizations

    SagarKumar,

     

    You need to make sure the slicer in the Power Bi is not set to anything. In other words, you will see all of the data. Within the Export to File for Power Bi Reports action you can pass the filter information using the ReportLevelFilters Filter. The syntax is- table name/field name eq value you are filtering on . 

     

  • SagarKumar Profile Picture
    4 on 15 May 2023 at 18:01:10
    Re: Apply different filters to a Power BI Reprt visualizations

    Hi

    I am trying to do similar thing. I want to export power bi report to pdf using power automate flow based on the slicer selected in power bi. But my report doesn't get exported to pdf as per the dynamic slicer value rather it gets exported with default value with which report was saved while publishing. Can you please help me to achieve this. 

    I am passing tablename/columnname eq 'value' in reportfilter in the export to file part. 

     

    Thankyou in advance for your help

  • M_Whitenight Profile Picture
    on 28 Feb 2023 at 20:33:13
    Re: Apply different filters to a Power BI Reprt visualizations

    I found the resolution. Just needed to make multiple tables and then apply filters unique to each level. 

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 > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 83

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started