Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
o59393
Post Prodigy
Post Prodigy

Conditional formatting now working right with Power BI

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

sadsaaa.JPG

 

There seems to be something wrong with Power BI:

 

dsfdsfsfsd.JPG

 

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

 

1 ACCEPTED SOLUTION
nandukrishnavs
Super User
Super User

@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

 

nandukrishnavs_0-1597647071500.png

nandukrishnavs_1-1597647103889.png



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂

 

 


Regards,
Nandu Krishna

View solution in original post

2 REPLIES 2
nandukrishnavs
Super User
Super User

@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

 

nandukrishnavs_0-1597647071500.png

nandukrishnavs_1-1597647103889.png



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂

 

 


Regards,
Nandu Krishna

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.