Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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..
Solved! Go to Solution.
Hi @Anonymous
You can Either select the Card and go to
Or create a DAX measure for the purpose
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
@Anonymous
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
@Anonymous
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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes.. but my question was different ..:)
Anyways thanks for helping out
Hi @Anonymous
You can Either select the Card and go to
Or create a DAX measure for the purpose
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |