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

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.

Reply
praabburi
Frequent Visitor

Icon Conditonal Formatting

Hi All,

 

I have requirement where I need to do icon condition formatting like < 75 red and between 75 to 98 yellow and above 99 its green.Capture.PNG

 

Wherever Ach% is less than 75% it conditional formatting should show red and between 76 and 98 it should show as yellow and above 99 it should show green.

 

@pabburi 

 

Thank you.

1 ACCEPTED SOLUTION
JosefPrakljacic
Solution Sage
Solution Sage

Hey @praabburi ,

 

here is a great article that shows you how to get the work done.

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

View solution in original post

2 REPLIES 2
kamalmsharma
Helper II
Helper II

Hello @praabburi ,

 

You can achieve this by using "conditional formatting" of required column. 

 

Pls refer this video from Curbal which explains it very well.

 

https://www.youtube.com/watch?v=MAISRa88bl0

 

Do let us know if it helped.

 

Cheers,

Kamal

www.addendanalytics.com

 

JosefPrakljacic
Solution Sage
Solution Sage

Hey @praabburi ,

 

here is a great article that shows you how to get the work done.

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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