Forum Discussion
Multiple Legends via Selection - Line Chart
I am using a line chart and am trying to use multiple columns as legends, so that users can switch between the way in which the data is split up, for example: via product type, or via vendor, or via binned cost. Is there a workaround to be able to do this?
Hi Anonymous
It can be done with the help of Perspective.
You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools
Here is the link to the steps.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives
5 Replies
Hi Anonymous
It can be done with the help of Perspective.
You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools
Here is the link to the steps.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives
HI Anonymous ,
Can you share some sample data and the expected output.
Also, see if this helps.
https://www.youtube.com/watch?v=_sxLEGRCo28&t=182s
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)Harsh,
This is not the dataset I am using, but it paints the picture I am going for. You can see that I placed "Country" on the Legend. Now if I wanted to split sales up by "Product Category" or "Region", as a desktop user, I can do that. But my end users, without pro-accounts cannot. Is there a workaround, so that the end user can select a drop down to change the Legend. So they can split sales up via "Country", or "Region", or "Manufacturer", etc.
Anonymous
I think I solved it. I used the dynamic x-axis solution, and applied it to the legend, see below: