Forum Discussion
ianf123
Helper II
Helper IIMatrix - show only rows which have a zero value
Hi - is there a way to "filter" the above matrix so it shows only rows which have a zero value? For info, this is set up with "switch values to rows" option on.
By SUM measures do you mean that they are implicit measures, i.e. that you have dragged a column into the visual and Power BI automatically creates a SUM aggregation for you? If so, create explicit measures like
My Measure = SUM( 'Table'[Column' ) + 0and use these instead. You will then be able to filter their values in the filter pane.
v-aatheeque
Community Support
Community SupportHi ianf123
To display only zero-value rows in your matrix: select the visual, drag the measure into the Visual-level filters pane, and set the filter to show values equal to 0.
Hope this helps !!
ianf123Helper II
Helper IIThe issue is that when I do that, I am not able to adjust anything with the filter. I think the issue is that the measures in the matrix are totals / "SUM" measures.