Forum Discussion
DAX: ConditionalFormatting on Percentages in Matrix doesn't react
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 , Percent column if marked as % the values are between 0 and 1 where 1 is displayed as 100, and so we should use .2 for 20% .5 for 50% and use number.
Percent here means distribution of data between min and max values
As you can see I mention that as an example too. It does not work in my situation apparently.
I have tried:
0 - 0.1 and 0.1 - 0.3 as number, without success
0 - 10 and 10 - 30 as percentage without success
0 - 0.1 and 0.1 - 0.3 as percentage, also without success
That's why I made a test measure to check whether it gives a 0 or 1, and that already clearly shows weird results.