Forum Discussion
Multiple Legends via Selection - Line Chart
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:
Hi Anonymous ,
It's glad to hear that your problem has been resolved. Thanks for sharing your solution here. Could you please mark your last reply as Answered? It will help others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Rena