Individual Average Line in Bar Chart

[Anonymous]

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.

[Ashish_Mathur]

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]

Hi @Ashish_Mathur  Thanks for your reply.

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

[Ashish_Mathur]

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.

[ryan_mayu]

@Anonymous 

please see the attachment below. hope it is helpful.

[Anonymous]

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

[ryan_mayu · Accepted solution]

@Anonymous 

please see the attachment below

[Anonymous]

Thanks @ryan_mayu 

[ryan_mayu]

you are welcome