Matrix - show only rows which have a zero value

[ianf123]

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.

[Greg_Deckler]

@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. 

https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M5...

[ianf123]

Thanks - I tried the filter pane but it wont let me change anything for the fields in question.

[v-aatheeque]

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 !!

[ianf123]

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.

[johnt75 · Accepted solution]

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' ) + 0

and use these instead. You will then be able to filter their values in the filter pane.

[v-aatheeque]

Hi @ianf123 

Just following up on the suggestion shared earlier by @johnt75  about replacing implicit measures with explicit ones (e.g., My Measure = SUM('Table'[Column]) + 0).

Were you able to try this approach, and did it resolve your filtering issue?

[v-aatheeque]

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? 

[v-aatheeque]

Hi @ianf123 

We haven’t heard from you on the last response and was just checking back to see if your query was answered,

Otherwise, will respond back with the more details and we will try to help .