Dax Conditional Formatting

[michaelag]

Hi I have struggled for few days now reading posts and trying all variations on how to build a conditional DAX and no matter which way i do it, it doesn't give me the result that I'm after.....
My original DAX is calculating diff sections as per below and what I'm after is one DAX that can change the colours accordingly, posted below too

Selected_Actual_Values_Performance% =

VAR CurrentItem=SELECTEDVALUE('Performance % Template'[Perforamnce %])

RETURN

SWITCH(TRUE(),

CurrentItem="Revenue %",[All_Income_VarPerc],

CurrentItem="Parts Mix %",[Parts_RatioPerc_Var],

CurrentItem="Panel GP %",[Panel_GP_Perc_Var],

CurrentItem="Parts GP %",[Parts_GPPerc Var],

CurrentItem="Paint GP %",[Paint_GPPerc_Var],

CurrentItem="Sublet GP %",[Sublet_GPPerc_Var],

CurrentItem="Liquid %",[Paint Liquid Perc Var to Budget],

CurrentItem="Consumables %",[Paint_Panel_ConsumablesPerc_Var],

CurrentItem="Overheads %",[OPS_ExpensesPerc_Var],

CurrentItem="Office Wages %",[Office Wages RatioPerc Var to Bud],

CurrentItem="Total GP %",[OPS_Total_GPPerc_Var],

CurrentItem="EBITDA %",[OPS_EBITDAPerc_Var])

Colours 

Selected_Actual_Vaues_Performance%_Colour =

SWITCH(TRUE(),

[All_Income_VarPerc]<=0.00,"Red","Green",

[Parts_RatioPerc_Var]>=0.00,"Red","Green",

[Panel_GP_Perc_Var]<=0.00,"Red","Green",

[Parts_GPPerc Var]<=0.00,"Red","Green",

[Paint_GPPerc_Var]<=0.00,"Red","Green",

[Sublet_GPPerc_Var]<=0.00,"Red","Green",

[Paint Liquid Perc Var to Budget]<=0.00,"Green","Red",

[Paint_Panel_ConsumablesPerc_Var]>=0.00,"Red","Green",

[OPS_ExpensesPerc_Var]<=0.00,"Green","Red",

[Office Wages RatioPerc Var to Bud]<=0.00,"Green","Red",

[OPS_Total_GPPerc_Var]<=0.00,"Red","Green",

[OPS_EBITDAPerc_Var]<=0.00,"Red","Green")

Looking forward to suggestions on how to get past this

thank you

[mwegener · Accepted solution]

Hi @michaelag ,

try this.

Selected_Actual_Vaues_Performance%_Colour =
VAR CurrentItem =
    SELECTEDVALUE ( 'Performance % Template'[Perforamnce %] )
RETURN
    SWITCH (
        TRUE (),
        CurrentItem = "Revenue %", IF ( [All_Income_VarPerc] <= 0.00, "Red", "Green" ),
        CurrentItem = "Parts Mix %", IF ( [Parts_RatioPerc_Var] >= 0.00, "Red", "Green" ),
        CurrentItem = "Panel GP %", IF ( [Panel_GP_Perc_Var] <= 0.00, "Red", "Green" ),
        CurrentItem = "Parts GP %", IF ( [Parts_GPPerc Var] <= 0.00, "Red", "Green" ),
        CurrentItem = "Paint GP %", IF ( [Paint_GPPerc_Var] <= 0.00, "Red", "Green" ),
        CurrentItem = "Sublet GP %", IF ( [Sublet_GPPerc_Var] <= 0.00, "Red", "Green" ),
        CurrentItem = "Liquid %", IF ( [Paint Liquid Perc Var to Budget] <= 0.00, "Green", "Red" ),
        CurrentItem = "Consumables %", IF ( [Paint_Panel_ConsumablesPerc_Var] >= 0.00, "Red", "Green" ),
        CurrentItem = "Overheads %", IF ( [OPS_ExpensesPerc_Var] <= 0.00, "Green", "Red" ),
        CurrentItem = "Office Wages %", IF ( [Office Wages RatioPerc Var to Bud] <= 0.00, "Green", "Red" ),
        CurrentItem = "Total GP %", IF ( [OPS_Total_GPPerc_Var] <= 0.00, "Red", "Green" ),
        CurrentItem = "EBITDA %", IF ( [OPS_EBITDAPerc_Var] <= 0.00, "Red", "Green" )
    )

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[michaelag]

Thank you 🙂 Worked a treat 🙂