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
9 years ago

Hi lailailaieric,

 

You are adding the Average as a measure correct? When you add a measure the calculations are based on the variables that you chose in your visuals so you are looking at the average of MEasure 2 of Singapure so this gives you the value of Singapure.

 

You need to add the analytics to your chart and then choose average in that you can also chose in wich measure you want the average and then add it, see print below any question please tell me.

 

If the average is for both measures you then need to change your DAX formula in order to achieve the total average, but to help you with that I will need further information on you data.

 

 

Regards,

 

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    I have done the same way as you said going to analytics pane and create an average line.

     

    But the issue is the average line value on the bar and the same value when i put on single row chord is not matching.

     

    Could you please help me out on the issue. Thanks.

     

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

      Hi Anonymous,

       

      Are the two visuals (bar chart and card) with the same filters applied?

       

      Should work the same way, I tried it and only when making different filters or context then the results didn't match.

       

      Regards.

      MFelix

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI MFelix

         

        Have applied same filters for both chord and bar but still having the same issue as data contains na, n/a, hourly, included, only twice and so on with few numbers.

         

        I did validation for all the text fields using whole number as a data type but no idea from where it is taking and giving some wrong values between two charts.

         

        Thanks you but if you can do help me out on this it would be a great pleasure.