Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional Formatting for Matrix seems to skip a condition

I've got this matrix, with the fields Date, Category (each row in the matrix is a category) and Sold%.

Sold% is a measure:

Percentage =
VAR numerator = COUNTROWS(
FILTER(
ImportedData,
ImportedData[Products] <> "sold")
)
RETURN DIVIDE (numerator, ImportedData[TotalProducts])

 

The issue is the formatting on the matrix doesn't work how I expect it to. I've got these thresholds for the matrix's conditional formatting to indicate the percentage of products sold. 

 

 
 

For some reason, the matrix appears like this (91% shouldn't be that shade of green for example)

Just to check, I changed the top threshold to blue to see what happens

And 91 becomes blue:

 

Any ideas what could have gone wrong? Any help is appreciated.

  • Anonymous , Change all percent to the number and use number like .8 for 80%

2 Replies

  • Anonymous , Change all percent to the number and use number like .8 for 80%

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, it worked! Very strange how the matrix is like that.