Hide / Unhide Column Values in Matrix when a filter is applied by clicking on another visual

[Anonymous]

See below Visual 1 and 2. Would like to hide/unhide columns in matrix when user clicks on Visual 1. Any help is greatly appreciated.

V1 User selects to apply filter)

V2 Before Filtered)

V2 After Filtered)

[v-yinliw-msft]

Hi @Anonymous ,

If I understand you correctly, you can try this method:

This is the normal condition. 

Then Click the cluster column visual, select Format:

Click the Edit interactions.

The matrix will have this black point and the filter icon:

Here is the different when you select the column in the cluster column visual.

About visuals interact, you can refer this documentation:

Change how visuals interact in a report - Power BI | Microsoft Learn

Is it what you expect?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Clarification: I want visual 2 to be a matrix with the following structure

Level 1 fields) date type column (i.e. 2022.39, 2022.40)

Level 2 fields) countLastWeek, countThisWeek, delta

Before Visual 1 is selected I want only 'countThisWeek' to be displayed. After filtering by clicking on Visual 1 I want all 3 Level 2 fields displayed. 

[Anonymous]

Note there are other slicers that I do NOT want to unhide the columns when selected