Hi all,I am trying to do conditional formatting on the background color. Settings are below but the result is meaningless. Does anyone show me what I am missing? Thanks a lot,

the number option is as indicated, but you must define the ranges in the form of a decimal, 3 = 0.03

Having trouble while conditional formatting | Microsoft Fabric Community

Anonymous
Not applicable
3 years ago
Hi,

Have you tried using "Number" insted of percent in the if statements? You could try working with tthe decimals instead. Other that that, this error seems odd.
- gkbrkkszgl
  New Member
  3 years ago
  Hi,
  Thanks for the reply. The number option also didn't work. I also tried to add decimal places while defining the conditional range and also tried measure without decimal (just for try) and the result is the same. I didn't understand as well?
  - Anonymous
    Not applicable
    3 years ago
    you would have to use the condition
    x >=0 < 0,03
    and
    x >= 0,03 <= 1
Syndicate_Admin
Administrator
3 years ago
the number option is as indicated, but you must define the ranges in the form of a decimal,

3 = 0.03
- gkbrkkszgl
  New Member
  3 years ago
  Hi,
  Yeah, that works with the decimal point and "number" options. But it still doesn't work with the percentage option. I did what I was trying to do but I think there is a minor bug in the program. Thanks a lot
gkbrkkszgl
New Member
3 years ago
Hi,
Yeah, that works with the decimal point and "number" options. But it still doesn't work with the percentage option. I did what I was trying to do but I think there is a minor bug in the program. Thanks a lot