Forum Discussion
Matrix - show only rows which have a zero value
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.
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 !!The 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.
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.