Forum Discussion
Solved
Dax Conditional Formatting
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
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
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.
2 Replies
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.Thank you 🙂 Worked a treat 🙂
