cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qngu
Frequent Visitor

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-values in the bar chart and the y-values are measures. For example, the value I want for decile 1 is -16-(-7)=-9. 

qngu_0-1657301265867.png

 

Any help greatly appreciated, Thanks.

qngu

1 ACCEPTED SOLUTION

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 )

 

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

6 REPLIES 6
PaulDBrown
Super User
Super User

In that case: 

Values minus mean for measure 1 =

VAR _Mean = DIVIDE([Measure 1] + Measure 2] + Measure 3] ...and so on upto Measure 10] , 10)

RETURN

[Measure 1] - _Mean

 

 

and repeat for each of the measures

 

You can't make it dynamic with your structure





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Sorry, I mis-understood you when you said each bar is a measure. Each bar is is calculated using a single measure. A simple example:

Table1

Date         | Value | Decile

1/1/2000  | -8      | '1'

1/1/2001  | -8      | '1'

1/1/2000  | -4.5   | '2'

1/1/2001  | -4.5   | '2'

....

 

Measure_1 = sum(Value) is set as the y-values and the x-values is set with the Decile column. So for decile 1, the measure will be -8+-8=-16, which is what we see in the bar chart and so on for each decile.

 

So there's only 1 measure, not 10. Sorry for the mis-understanding.

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 )

 

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Awesome. Thanks for the solution, I was looking for this and accepted this as the solutin as well.

PaulDBrown
Super User
Super User

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.