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.
Hello,
I am currently using a KPI and it has worked successfully when based it off a percentage goal. Unfortunately, some of the values purposely have no goal and instead of Neutral, the colour coding is formated as the "bad color."
Can someone help me with the DAX measure for this?
Thank you!
Hi @sdegroot
After testing, i can't make the same visual as you required.
According to this post, "the Neutral colour is for when you have two target values, if your measure falls between the two it is Neutral Colour, if it is above the higher target it is Good Colour, if below the lower of the two targets it is Bad Colour".
However, blank value can't make sense this way, so i modify the blank value to an alternative value to show neutral color.
Column = IF(ISBLANK([goal1]),[percetange]-0.01,[goal1])
Column 2 = IF(ISBLANK([goal1]),[percetange]+0.01,[goal1])
Best Regards
Maggie
Hello Maggie,
Thanks for looking into it! Were you able to use this in DirectQuery mode too? I wasn't able to use it and I know DirectQuery is very sensitive to adding new columns.
Thanks!
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |