Forum Discussion
Multiple legends on bar chart
Hi all,
I would like to accomplish something like this:
But I can not seem to find a solution for it.
Also, I would like to know how to make it show Q1 2019, Q2 2019, Q3 2019, Q4 2019, Q1 2020 ? If I select just "quarter", it sums Q1 for both years. Can't seem to combine it or hierarchy it like that when on legend?
Hi Anonymous ,
As I know, If you want to use multiple legend for year and month, I think you need to create measures for corresponding year and month, then use this in chart and don't add legend in chart.
In addition, If you want to show 2019 Q1, 2019 Q2...., I suggest you could use date hierarchy in axis and use category in legend, then when you click expand button, it will show result you want.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
As I know, If you want to use multiple legend for year and month, I think you need to create measures for corresponding year and month, then use this in chart and don't add legend in chart.
In addition, If you want to show 2019 Q1, 2019 Q2...., I suggest you could use date hierarchy in axis and use category in legend, then when you click expand button, it will show result you want.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.