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
Go to Solution.
The issue with the decimal part.
Try to use below DAX measure for applying the conditional formatting.
VAR __val =
ROUND ( [Check mix], 2 )
VAR __result =
__val = 1, "Green",
AND ( __val >= 0, __val < 1 ), "Red",
__val > 1, "Red"
Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂
View solution in original post
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")
Also try with 1.0 , 0.0 etc in rules
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021