Forum Discussion
M_SBS_6
2 years agoHelper V
Matrix Condition Formatting
Hi,
I have a Matrix table and I want to have a conditional format on a percentage value.
The lowest value being red, centre value orange and maximum being green.
I have the formatting set to
Gradient
Values only (as I don't have the totals)
Format empty values as 0.
The table has 3 rows.
I think the problem is that my value has a NaN output as its trying to take a percentage of (0.00 / 0.00) - 0.00 measure below:
(appval_prev / appval_curr) - appval_curr
Any idea how to resolve please?
Hi M_SBS_6
Have you tried using the DIVIDE function instead of slash. https://learn.microsoft.com/en-us/dax/divide-function-dax
1 Reply
- danextianSuper User
Hi M_SBS_6
Have you tried using the DIVIDE function instead of slash. https://learn.microsoft.com/en-us/dax/divide-function-dax