Conditional formatting now working right with Power BI

[o59393]

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

[nandukrishnavs · Accepted solution]

@o59393 

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 🙂

[amitchandak]

@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