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.
Hi all
I am using a conditional formatting with the following rules.
If equal to 1 then green
If >= 0 and less than 1 then red
If greater than 1 then red
There seems to be something wrong with Power BI:
I dont know why is taking the 1 values as red as seen above.
Any idea what could be wrong?
Here is the pbix
https://1drv.ms/u/s!ApgeWwGTKtFdhyDsUmWn7PR4vNTY?e=9kjOQF
Thanks
Solved! Go to Solution.
The issue with the decimal part.
Try to use below DAX measure for applying the conditional formatting.
Color =
VAR __val =
ROUND ( [Check mix], 2 )
VAR __result =
SWITCH (
TRUE (),
__val = 1, "Green",
AND ( __val >= 0, __val < 1 ), "Red",
__val > 1, "Red"
)
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
The issue with the decimal part.
Try to use below DAX measure for applying the conditional formatting.
Color =
VAR __val =
ROUND ( [Check mix], 2 )
VAR __result =
SWITCH (
TRUE (),
__val = 1, "Green",
AND ( __val >= 0, __val < 1 ), "Red",
__val > 1, "Red"
)
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@o59393 ,
Create a color meausre and try (example) with "Field" option in conditional formating
Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Also try with 1.0 , 0.0 etc in rules
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 | |
99 | |
87 | |
68 |