Forum Discussion
Solved
Conditional formatting for visual
Hello, I'm struggling to add some conditional formatting to a visual. I have a filter for Name, and then a filter for Date, this then dynamically changes another visual which displays Jump He...
Hi JoshP11 ,
I made simple samples and you can check the results below:
Average = AVERAGEX(ALL('Table'),[Jump Height]) Standard Deviation = CALCULATE(STDEV.P('Table'[Jump Height]),ALL('Table')) Measure = var ave =[Average] VAR sta = [Standard Deviation] RETURN SWITCH( TRUE(), MAX('Table'[Jump Height]) >= ave + sta, "Above Average", MAX('Table'[Jump Height]) >= ave + 0.5 * sta && MAX('Table'[Jump Height]) < ave + sta, "High Average", MAX('Table'[Jump Height]) >= ave - 0.5 * sta && MAX('Table'[Jump Height]) < ave + 0.5 * sta, "Low Average", MAX('Table'[Jump Height]) <= ave - sta, "Below Average", "Other" )An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi JoshP11 ,
I made simple samples and you can check the results below:
Average = AVERAGEX(ALL('Table'),[Jump Height])
Standard Deviation = CALCULATE(STDEV.P('Table'[Jump Height]),ALL('Table'))
Measure = var ave =[Average]
VAR sta = [Standard Deviation]
RETURN
SWITCH(
TRUE(),
MAX('Table'[Jump Height]) >= ave + sta, "Above Average",
MAX('Table'[Jump Height]) >= ave + 0.5 * sta && MAX('Table'[Jump Height]) < ave + sta, "High Average",
MAX('Table'[Jump Height]) >= ave - 0.5 * sta && MAX('Table'[Jump Height]) < ave + 0.5 * sta, "Low Average",
MAX('Table'[Jump Height]) <= ave - sta, "Below Average",
"Other"
)
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous - that worked perfectly!