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
