Colour Formatting Dax - SWITCH function

[Anonymous]

Hi Guys 

I keep hitting a brick wall, I have this formula but I keep getting errors OR it only picks up the first condition "Green" and the "Persian Blue" for all my completed items.

I am trying to do is get all information marked as complete with "Persian Blue", if it is not marked as complete I need a colour name on the basis of the % of budget used on the work 

Between:

0 - 40% Green

41 - 60% Yellow

60 - 79% Orange 

>80% Red

Background colour = SWITCH(TRUE(),

[DAX Status]="Complete","Persian Blue",

[% remaining - Report]=or([% remaining - Report]>=0,[% remaining - Report]<0.4),"Green",

[% remaining - Report]=or([% remaining - Report]>=0.41,[% remaining - Report]<0.6),"Lemon",

[% remaining - Report]=or([% remaining - Report]>=0.61,[% remaining - Report]<0.79),"Orange",

[% remaining - Report]>0.8,"Red")

Any help you guys can give me will be appreciated - youtube is getting me nothing ha 

Thank you 

Anne

[Anonymous]

@Anonymous ,

Check this - https://community.powerbi.com/t5/Community-Blog/Conditional-Formatting-Using-Custom-Measure/ba-p/1399855 if this helps you.

You can set the MIN and MAX values according to your requirement.

Appreciate your kudos!! Please mark my post as solution if this suits your requirement.

[AlB · Accepted solution]

Hi @Anonymous 

Background colour =
SWITCH (
    TRUE (),
    [DAX Status] = "Complete", "Persian Blue",
    AND ( [% remaining - Report] >= 0, [% remaining - Report] < 0.4 ), "Green",
    AND ( [% remaining - Report] >= 0.41, [% remaining - Report] < 0.6 ), "Lemon",
    AND ( [% remaining - Report] >= 0.61, [% remaining - Report] < 0.79 ), "Orange",
    [% remaining - Report] > 0.8, "Red"
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers