Forum Discussion

qngu's avatar
qngu
Frequent Visitor
4 years ago
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...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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 )

     

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Is each bar a measure then? If so, will there only ever be 10 data points?

qngu's avatar
qngu
Frequent Visitor
4 years ago

Yes, each bar is a measure. Yes, there will only ever be 10 data points in this case. I'm hoping that it can be generalized to the number of categories on the X-axis though.

 

Thanks for taking a look,

qngu