Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Individual Average Line in Bar Chart

We have Data Like

Month || This Year Count || Last Year Count

Jan       || 10                      || 5

Feb      ||  15                     || 10

Mar     || 20                       || 15

 

We need a bar chart with Month on X-axis and Counts(This Year Count,Last Year Count) on the Y axis.

Now,We need to plot a average line on 45/3=15(This Year Count Average) and another line on 30/3=10(Last Year Count Average)

I would appreciate some help to develop this visual.

Need Help
Tips and Tricks

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks ryan_mayu  for your Reply.
      We have tried the Measure and it is working fine.but when we select the month with the slicer, the average line is not affected.
      The Requirement we got is to change the average line according to the filter selected.
      Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Are This Year Count and Last Year Count actual measures that you have written or are they input data columns available in your base data file?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Ashish_Mathur  Thanks for your reply.

      We are using the Measures for Last and Current Year.
      Thanks.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        5 years ago

        Hi,

        Do these measures work?

        Average = averagex(all(calendar[Month name]),[This year count])

        Average1 = averagex(all(calendar[Month name]),[Last year count])

        Hope this helps.