multiple average lines in a line chart

[Anonymous]

Hi all,

I try to add two aberage lines in below line chart.

One for 2021, the other for 2022

Any tips how I can do that?

Thanks!

[Anonymous]

Hi @goncalogeraldes 

thanks for advise, was able to fix it

Have a good weekend.

John

[sctham]

@Anonymous Can you let me know how you fixed this as I want to do something similar? Thanks.

[goncalogeraldes · Accepted solution]

Hello there @Anonymous ! You can add multiple average lines in the "Analytics" Pane of a visual. Nevertheless, in your case you would need to create two separate measures (one with a filter for 2021 and another for 2022) and use them as a reference for your average lines. Alternatively, you can just add two card visuals with a measure for your average and filter each one for each year.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[sctham]

@goncalogeraldes Can you advise how to create measures with the years as filters? Thanks.