Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to show background color of my values in tables, like if values are between 20-60 : Red background else 61-90 : Yellow background.
I have tried conditional formatting , but i am unable to use <,> symbols in that . Isn;t it possible to format values using greater than and lower than symbols.
Thanks
Hi @AnandRanga
When using the Conditional formatting you can change it to Absolute values.
When you do this you can then set what you want that Absolute range to be, so for the lowest it would be 20, then 60 and then 90 and put your colours against those Absolute values. That should get it working for you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |