Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |