Forum Discussion

JoshP11's avatar
JoshP11
Helper II
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

JoshP11's avatar
JoshP11
Helper II
1 year ago

HI parry2k 

 

It's basically just this in the data so far whilst Ive been trying to work out how to do it.

 

NameDateJump Height
NAMEONE01/01/202440.3
NAMEONE01/04/202438.35
NAMEONE29/09/202440.05
NAMETWO02/04/202437.5
NAMETWO04/04/202439
NAMETWO04/12/202442.34
NAMETHREE01/01/202441.44
NAMETHREE20/01/202437.9
NAMETHREE27/01/202436.4
NAMETHREE15/02/202439.25
NAMETHREE22/04/202441.24
NAMEFOUR26/04/202441.5
NAMEFOUR11/05/202440
NAMEFIVE18/09/202439.45
NAMEFIVE21/09/202438.36
NAMEFIVE27/09/202438.7
NAMESIX02/03/202440.13
NAMESIX19/04/202442.22
NAMESEVEN22/04/202435.45
NAMEEIGHT09/09/202438.4
NAMEEIGHT28/09/202439.8
NAMEEIGHT29/09/202440.25
NAMENINE05/05/202444.45
NAMENINE08/09/202443.1
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • JoshP11's avatar
    JoshP11
    Helper II
    1 year ago

    Thank you Anonymous  - that worked perfectly!