Forum Discussion

lailailaieric's avatar
lailailaieric
Regular Visitor
9 years ago

Average Line across the Bar Chart

Hiii.    As I am trying to draw an average line for my bar chart, the numbers showed up as the average of the place themselves instead of the average as a whole. Can anyone solve this? Below would ...
Need Help
Show and Tell
Tutorial Requests
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi S184019,

 

Instead of the MEDIAN in the summarize, try to use the MEDIANX, this is an aggregator formula that does the median but calculating the values row by row and then returning the final result.

 

Regards,

MFelix

 

S184019's avatar
S184019
Icon for Advocate III rankAdvocate III
8 years ago

Hey MFelix,

 

Thank you for your super quick reply!  The difficulty might be a bit deeper than that.  I am not able to medianx of summarized('Locations'[Important_Column])) but that truly is a GREAT suggestion and point. 

 

Sincerely,

 

Mark

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Hi S184019,

     

    Without some data sample is difficult to give a better respons although you have the measures you use the data is fundamental to have the right response, if you can share a sample and expected result would be easier to give you a more accurate answer.

     

     

    Regards,

    MFelix