Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AnandRanga
Helper III
Helper III

conditional formatting in charts or tables ?

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

1 REPLY 1
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.