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
Do you know why the collors under "Actual/Plan Status" are displayed incorrectly?
You can find the file hear: Download the file
Thank you for the help
Hi @ignas,
Is [Actual/Plan Status] a calculated column or measure? The indicator colors are incorrect might be related to the formula. Please test whether below expressions can display expected colors.
Change IF('Key'[Var to Plan %]<=0,red,green) to
IF('Key'[Var to Plan %]=-0.0917,red,green) and IF('Key'[Var to Plan %]<=0,0,1)
By the way, I didn't see relative table view ('Key' and 'Key'[Var to Plan %]) and above visual in the uploaded .pbix file.
Regards,
Yuliana Gu
Hey @v-yulgu-msft
Thank you for the response.
It is calculated as column because as measure does not allow change Data Category to URL address.
I do not understand what you ask me to change. I changed it and there is nothing positive with it.
Could you please try to enter the formula yourself and see if it works? And if yes could you please share with me?
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 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |