Forum Discussion
"Cell Elements" formatting rules
Hi! Isn't it strange that in the format style rules under "Cell Elements" there's no option to enter "< than 0"?
Hello Wiegin ,
what you do is that you make it greater than or equal to and clear the zero and it will put automatically a value named min and then you put the less than in the second cell.
try it , it will work.
3 Replies
Hii Wiegin
But you can still apply a less-than-zero rule.
Simply type a negative number in the value box
Example:
- Set the rule to Number
- Then enter -0.0001 (or any negative value)
Power BI automatically interprets it as:
“Format when value < 0”
So even though the UI doesn’t show “<”, using any negative value works as the “< 0” rule.
You can see in image below as example
Hello Wiegin ,
what you do is that you make it greater than or equal to and clear the zero and it will put automatically a value named min and then you put the less than in the second cell.
try it , it will work.
It was so easy... 😅 Thank you!!!
