Matrix with blank values - hiding blanks?

[AC23VM]

Hi there.  Just a quick question.  I have a matrix that displays a a set of data, say A-E.  In December, there were no instances of A.  But regardless if I have a slicer for December, the matrix still shows a row for A, albeit one with zero values.  If I go into the filter pane, A isn't there (because it isn't in December) so I can't untick the box to not show it.  Is there a way around this?  Ideally, I'd like these rows with zero values not to show up at all.

[bhanu_gautam · Accepted solution]

@AC23VM , To hide rows with zero values in your matrix, you can use a measure to filter out those rows.

Create a measure that calculates the sum of the values for each row.

TotalSales = SUM('Sales'[Amount])

Use this measure to filter out rows with zero values. You can do this by adding a visual-level filter to your matrix visual. Here’s how:
Select your matrix visual.
In the Visualizations pane, drag the measure you created (e.g., TotalSales) to the Filters on this visual section.
Set the filter condition to show only rows where the measure is greater than zero.

[AC23VM]

Ah cool.  I already have such a measure.  I just filtered it to be less than zero.  Grand, thank you very much!