Hide values less than 0 in a matrix

[Anonymous]

Hi.

I have a matrix with details of a table organized by month and year hierarchy. But when down to month detail level. The matrix show the months without values and need hide this.

I need that show a matrix like this

To calculate the values Im use a measure that count the rows of the table. And for the date use an automatic hierarchy from a column with date values.

Can you help me please.

Thanks.

[MattAllington · Accepted solution]

Visuals will always display a column if there is at least ine non blank value. If there is a column of 0s, they will be displayed. You can simply not load zero values in your data model (filter on load) or you can write measures that return blank rather than zero.