Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I hope someone can help, cause sometimes propagation and filter context is difficult.
Regards
Ron
Solved! Go to Solution.
Here's the measure that works:
Hi @Padycosmos thanx for you answer
I changed the measure as follows (by the way I replaced Amber by Purple, because for Amber it returs Blue, which seems odd)
You have >=_differ in "Purple" and <= _differ in "Red", you need to remove one of the = . Then it should work
Hi @Padycosmos
unfortunately no change
I changed
Could you please move "red" as the first statement, "purple" as the second and "green" as the last and try again?
Hope this works
Color =
var _differ = 1 - [KPI perc]
RETURN
SWITCH(
TRUE(),
[Check Against Target] >= 1, "Green",
[Check Against Target] >= _differ && [Check Against Target] < 1, "Purple",
[Check Against Target] < _differ && [Check Against Target] < 1, "Red"
)
If the data is not sensitive, could you please share the pbix file?
Hi @Padycosmos
I can share the pbix file. Looking how to do that, but can't find it. How do I attach a pbix to a reply?
Here's the measure that works:
You can put the file in your google drive and paste the link here. Please note to enable access to th file for anyone with the link
Hmm, ok , never used google drive. Will try later today. I can also send it personally if I have your email
You may send it to padycosmos@gmail.com
In Power BI, though the display format is %, the numbers are stored as decimals. Please make the following changes and try again
var _differ = 1- [KPI perc]
Replace both the 100s in the SWITCH() to 1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |