Conditional Formatting for zero values in a matrix visual with varying background colors

[zahlenschubser]

I am trying to set up conditional formatting so I don't see zeroes in my matrix visual, but if I for example format zeroes as white the grey lines will still show them.

[Ritaf1983 · Accepted solution]

Hi @zahlenschubser 
There is 2 options to solve the issue:

1. don't use an alternate background for rows, use horizontal grid instead :

2. instead of conditional formatting , "format" 0 as blank from dax :
fixed_measure = if ([measure ] = 0, "",[measure])

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[zahlenschubser]

I feel so stupid right now ... I didn't even think of summing up the amounts by measure, I just let PBI do it in the matrix.

Solved, thanks!

[Idrissshatila]

Hello @zahlenschubser ,

try to add an if statement to the measure that says if the field = 0 then Blank