Conditional formatting for visual

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.