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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prv_1401
Helper I
Helper I

Conditional formatting of Icon colour

Hi Everyone !!

I got a card and Icon which shows the fillrate% and the indication icon respectively.

I have attached below the images of it .

 

Requirement : I want the card and Icon to turn green when the % is above 99.00 % . So when it's below 99.00 ( red ) and when above 99.00% (green) 

 

I tried some measures and I could get the red colour but it isn't changing to green when it's above 99% . Appreciate any help .

Thank You

 

IMG_20220911_181240.jpg

IMG_20220911_181231.jpg

@PaulOlding @v-shex-msft @v-jianboli-msft Thank you all who helped me previously.

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@prv_1401 Seems like your formula should be >0.99 instead of 99


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

@prv_1401 Because the actual value is actually .996. You have it formatted to display as a percentage which makes it display on the screen as 99.60%. Formatting is separate from the actual value. In fact, the value may actually be .996 but since you have 2 decimal places of formatting it shows as 99.60%. Another example, the actual value might end up being .996347 but if you only have 2 decimal places of formatting then it will be 99.63%. Formatting is controlled via the Format section of the Measure Tools or Column Tools tabs in the ribbon. You can also have custom format strings, which are a treat.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@prv_1401 Seems like your formula should be >0.99 instead of 99


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  Thank you so much. It worked.
Can you tell me why should we put it in that way ( like 0.99) ?
I am new to PowerBI so curious to know .

@prv_1401 Because the actual value is actually .996. You have it formatted to display as a percentage which makes it display on the screen as 99.60%. Formatting is separate from the actual value. In fact, the value may actually be .996 but since you have 2 decimal places of formatting it shows as 99.60%. Another example, the actual value might end up being .996347 but if you only have 2 decimal places of formatting then it will be 99.63%. Formatting is controlled via the Format section of the Measure Tools or Column Tools tabs in the ribbon. You can also have custom format strings, which are a treat.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  Ok got it. Thank you so much ❤️

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors