Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |