Forum Discussion
Solved
How to de-mean Bar Chart?
Hi All, From the example bar chart below, the blue dotted line is the average line. (-16+-9+...)/10 = -7. Instead of plotting the average as a line, I would like to subtract (-7), to all the y-va...
Ok, that makes way more sense.
Try:
Values minus mean for measure 1 = VAR _Mean = AVERAGEX ( ALLSELECTED ( Table[Decile] ), [Your measure] ) RETURN IF ( NOT ( ISBLANK ( [Your Measure] ) ), [Your Measure] - _Mean )
Ok, that makes way more sense.
Try:
Values minus mean for measure 1 =
VAR _Mean =
AVERAGEX ( ALLSELECTED ( Table[Decile] ), [Your measure] )
RETURN
IF ( NOT ( ISBLANK ( [Your Measure] ) ), [Your Measure] - _Mean )
Awesome. Thanks for the solution, I was looking for this and accepted this as the solutin as well.