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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Randqaq
New Member

Conditional Formatting for Card Visual

Hello everyone. 

 

How can i apply conditional formattinG to a card value without coding?

i have three conditions:

1. #>=0 and is <30 then Red

2. #>=31 and is <70 then Orange

3. #>=70 and is <= 100 then Green

but the conditional formatting is not being reflected on values. only the first format is being applied. 

TEST1.pngRESULT 1.png

0587d2c1-1b26-4994-902b-b07fd29688bf.png

 

RESULT 3.png

 

2 REPLIES 2
qqqqqwwwweeerrr
Super User
Super User

Hi @Randqaq 

 

As i can see you are using "%" value in card but in coditional formatting box you have selected the number change that to percetange. 

 

Here the thing you need to check

1. You measure is returning what kindof numeric value decimal or whole number.

2. based on above observation selected the number or percentange (here what i seem it should be percetange but please double check)

 

by following theses two steps youissue should be resolved.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

Anonymous
Not applicable

Hi @Randqaq 

 

It seems that you are displaying percentages. I don't know how your data looks like but sometime percentage have a value range of [0, 1].

 

So, to make sure your conditional formating works with %, you should try these rules:

  • 0-0.3 -> red
  • 0.31-0.7 -> orange
  • 0.7-1 -> green

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors