Forum Discussion

Titatovenaar2's avatar
Titatovenaar2
Advocate II
4 years ago
Solved

DAX: ConditionalFormatting on Percentages in Matrix doesn't react

Hi everyone,   I try to color all percentages of measure <pB&B_B1> (renamed in column as 'B1') red between 0 and 10%, and orange between 10 and 30%.   EDIT: The following all doesn't work: 0 - ...
Need Help
  • Titatovenaar2's avatar
    Titatovenaar2
    4 years ago

    I found the solution, I didn't realize that FORMAT() function, even though setting it to a '%' via "percentage", it also changes it's datatype to String. Therefore it returned a 0 even while I compared it with an insanely high number of 99999999999999999-ish. Once I removed the FORMAT() function, and changed the datatype of the measure directly to '%', the 0 - 0.1 and 0.1 - 0.3 as numbers works perfect!

Titatovenaar2's avatar
Titatovenaar2
Advocate II
4 years ago

I found the solution, I didn't realize that FORMAT() function, even though setting it to a '%' via "percentage", it also changes it's datatype to String. Therefore it returned a 0 even while I compared it with an insanely high number of 99999999999999999-ish. Once I removed the FORMAT() function, and changed the datatype of the measure directly to '%', the 0 - 0.1 and 0.1 - 0.3 as numbers works perfect!