Forum Discussion
multiple average lines in a line chart
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!
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
4 Replies
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 Geraldesgoncalogeraldes Can you advise how to create measures with the years as filters? Thanks.
Anonymous Can you let me know how you fixed this as I want to do something similar? Thanks.
