topic Hide / Unhide Column Values in Matrix when a filter is applied by clicking on another visual in DAX Commands and Tips

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

Anonymous — Wed, 19 Oct 2022 21:32:10 GMT

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)

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

Anonymous — Wed, 19 Oct 2022 21:35:58 GMT

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

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

v-yinliw-msft — Thu, 20 Oct 2022 09:36:39 GMT

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.

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

Anonymous — Thu, 20 Oct 2022 16:37:17 GMT

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.