Forum Discussion
Conditional Formatting for zero values in a matrix visual with varying background colors
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
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!
