Color Coding In Card Object

Mohsen_2020 · ‎11-09-2020

Dear Team,

I need to make a color coding in a card showing the pecentage of delayed actions so if the delay percentage equals 0% the color of background suppose to be green and if it's higher than 0% "1% till 100%" the color of background suppose to be green.

Please advise.

Regards,

Mohsen

mahoneypat · ‎11-09-2020

Make a measure like this

Card Color = IF([Your Measure]>0, "Green", "Red")

And then, in the format options for the card, hit the fx under Background color and choose field value and this measure.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Mohsen_2020 · ‎11-09-2020

Please find the below results after applying the measure, both results are giving the same BG red color, please advise.

v-yingjl · ‎11-10-2020

Hi @Mohsen_2020 ,

Which field you have put in the right side card visual? Seems like not [Delayed_Calls_Average] measure but others, or did you apply any filters in the report?

The [Card Color] measure only return red becasue [Delayed_Calls_Average] value is always > 0, [Delayed_Calls_Average] measure only returns a summarize value in the card visual. What is your [Delayed_Calls_Average] looks like?

Basically needs more information about this issue for further discussion. Or you can consider sharing a simple sample file.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.