Forum Discussion
Question about power bi matrix and filter
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!
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.
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.
3 Replies
- Ritaf1983
Super User
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.
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
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.
