Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dz0001
Regular Visitor

two different visual level filters in different matrix table

Hi There,

 

I create one report with two matrix tables, one matrix table has one set of visual level filter (table 1). Then I add another matrix table, and want to add different visual level filter (table 2), however the visual level filter from table 1 is automatically added in visual level filter of table 2, and I cannot find way to delete them, so my visual level filter for table 2 doesn't work at all because of this.

 

Do I miss anythng here?

 

Thanks

Don

3 REPLIES 3
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @dz0001,

 

For those fields and measures you added to a visulaization, they will appear in Visual Level Filters automatically and cannot be removed. If you don't want them to filter the corresponding visual, just don't apply any filter rules for them. Besides, some other fields/measures which are not displayed in visual can be removed from the visual level filters section.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank y'all for the advice. 

 

This is really strange, I have two reports, for exmple, each report has one matrix table, Report 1 is revenue only (visual level filter), Report 2 is expense only (visual level filter).  Then I want to put Revenue and Expense matrix report at the same report, so I just copy M2 into Report 1 right under matrix table 1, however Matrix 2 table seems inherited visula level filter from Matrix 1 and I cannot remove them, my Expense Matrix ends up showing nothing, this drives me crazy

Ashish_Mathur
Super User
Super User

Hi,

 

Click on the second visual and remove the field/measure (which belongs to the first visual) from the visual level filter box in the Visualisation pane.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.