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
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.
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 .
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
I found the resolution. Just needed to make multiple tables and then apply filters unique to each level.
stampcoin
83
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1