Forum Discussion
Matrix - 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.
8 Replies
ianf123 You'll need something like a Complex Selector. Or you may be able to just use the Filter pane and set it to have all the measures only showing 0.
Thanks - I tried the filter pane but it wont let me change anything for the fields in question.
Hi 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 !!
