avg line in bar graph but the it should be based on some other measure (not the one in visual)

[Raj007]

Hi All,

Thanks for your time. I have gone through some search but could not find..

Is it possible to get the average line in the bar graph say clustered bar graph ...say for example i have year in axis

2019 2020 2021 2022 and the measure is count of ticket numbers.. i want to get the average of last 3 only ( i do not want to include the 2022 in it)...could not find anything in my search,,,

any help is highly appreciated

[v-kkf-msft · Accepted solution]

Hi @Raj007 ,

Please create the measure and then add a constant line (You may need an updated version of Desktop to add constant lines).

Ave = 
AVERAGEX (
    TOPN ( 3, VALUES ( 'Table'[Year] ), CALCULATE ( MAX ( 'Table'[Year] ) ), ASC ),
    [SumTickets]
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Raj007]

i have may 2020 version...is this the reason why iam not able to see the options?