cancel
Showing results for
Did you mean:
Regular Visitor

KPI colour - Conditional Formatting

Hello,

I have built a few KPI cards as follows ..

So.. It has a value coming out of a Measure (Can be percentage or value in Millions) and Goals coming out of a table containing all the targets based on months.

Now I want to change the colour of the Value coming from the Measure based on the Goals.

I want it to turn green even when it approaches the goal ..

say if the Goal is 50% and my value is 41% ..it should be green

if its 31% its orange and below 30% its red.

How can I achieve this?

May be this is simple.. but I am new to PBI and would love your responses..

2 ACCEPTED SOLUTIONS
Community Champion

You can Either select the Card and go to

Or create a DAX measure for the purpose

Regards
Amine Jerbi

and you can follow me on

Regular Visitor

Hello,

Thanks..

But How can I use this to set up the rules for all three colours?

I tried to set up the same rules for all the three (good, neutral and bad colour)..

Isnt this the same as acking it up with DAX?

Thanks

6 REPLIES 6
Super User IV

@Sanath_95

Create a measure that gives you the color based on the conditions as follows:

``````CF Goal =
SWITCH(
TRUE(),
[Actual] >= .41 , "Green",
[Actual] >= .31 , "Orange",
"Red"
)``````

Select your KPI Visual then click each fx under Color Coding

Click on the  Format By and choose Field Value and under Based on, select your the Measure CF Goal

Repeat for all three colors.

Proud to be a Super User!

Regular Visitor

Hello,

Thanks..

But How can I use this to set up the rules for all three colours?

I tried to set up the same rules for all the three (good, neutral and bad colour)..

Isnt this the same as acking it up with DAX?

Thanks

Super User IV

@Sanath_95
The conditions are set up in the measure CF Goal. You need to select Format by field value and select the CF goal for BAsed on Field. Refer to my 3rd screenshot

Proud to be a Super User!

Regular Visitor

Yes.. but my question was different ..:)

Anyways thanks for helping out

Community Champion

You can Either select the Card and go to

Or create a DAX measure for the purpose

Regards
Amine Jerbi

and you can follow me on

Regular Visitor

Hello..

I saw this option is available individually for Good colour, neutral colour and bad colour...

How can I set this up for KPI card?

Announcements

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.