Dax Conditional Formatting

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.