Chart with multiple Columns/Legends

[rcabrera]

In Excel, I have the ability within a line chart to have multiple columns/legends. In PowerBI, this option is not available as I try to add a 2nd legend and it does nothing. Can this be accomplished?

Thank you.

[Shahid12523]

Power BI only supports one Legend field per visual. Unlike Excel, you can’t add multiple legends directly.

Workarounds:

Combine fields into a calculated column/measure to create a single legend (e.g. Category & " - " & SubCategory).

Use Small multiples (a separate chart per legend value).

Overlay visuals (two charts on top of each other) if you need different legends.

So: multiple legends like Excel = not directly supported, but can be simulated.

[Anonymous]

@rcabrera 

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

[urspalani]

For your requirement, you can vote below idea:

Ability to use multiple fields on a legend like an Excel pivot chart