Multiple Legends via Selection - Line Chart

[Anonymous]

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?

[pranit828 · Accepted solution]

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

[harshnathani]

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)

[Anonymous]

@harshnathani

I think I solved it. I used the dynamic x-axis solution, and applied it to the legend, see below:

https://www.youtube.com/watch?v=lFd2hjkKz_Q

[v-yiruan-msft]

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 

[Anonymous]

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.