Forum Discussion

dz0001's avatar
dz0001
Regular Visitor
8 years ago

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...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

dz0001's avatar
dz0001
Regular Visitor
8 years ago

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