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.
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.
Hi ianf123
Just checking in on the suggestion shared earlier by @johnt75 about replacing implicit measures with explicit ones (for example:
My Measure = SUM('Table'[Column]) + 0).Have you had a chance to try this approach, and did it resolve your filtering issue?