Forum Discussion
Conditional Formatting for zero values in a matrix visual with varying background colors
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.
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
3 Replies
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
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!
Hello zahlenschubser ,
try to add an if statement to the measure that says if the field = 0 then Blank
