Question about power bi matrix and filter

[PowerBiNovice_1]

I have the above matrix, with the column "Widget_Color" as "filters on this page", when I select a specific color it filters the matrix nicely, my question is.....if NO filters  (colors from Widget_Color) are selected is there a way to display in the matrix only the column year and the totals as shown below?

your help is appreciated, thank you!

[Ritaf1983 · Accepted solution]

Hi @PowerBiNovice_1 

Yes, even if the field is not presented in the visual it can filter the data, according to the model and its relationships.

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

[Ritaf1983 · Accepted solution]

Hi @PowerBiNovice_1 

Yes, even if the field is not presented in the visual it can filter the data, according to the model and its relationships.

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

[PowerBiNovice_1]

Hello Ritaf thanks for replying, the field is presented in the visual but I would like to hide that field/column in the matrix if no value is selected in the filter, not sure if that is possible to do

[Ritaf1983 · Accepted solution]

Sorry for misunderstood @PowerBiNovice_1 

Unfortunately, it is not possible to hide/show columns conditionally based on filter selection.

Please refer to the linked discussion about similar ( not the same, but with similar needed functionality)

https://community.fabric.microsoft.com/t5/Desktop/Hiding-columns-if-blank/m-p/341645

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