Forum Discussion
Line and column - legend
- 1 year ago
Hello KripaShankar
You can try this
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- 1 year ago
Hi KripaShankar
It is not currently possible to use legends on both the line and column. Legend is supported on columns only.
- 1 year ago
Hi KripaShankar ,
Thank you for posting your query in the Microsoft Fabric Community. In Power BI, the Line and Clustered Column chart supports only a single legend by default, typically associated with the column series. Unfortunately, Power BI does not currently offer built in support for displaying separate legends for both the line and column series. Thank you to all community members for sharing your valuable insights and workarounds.
Recommended Solution
You can create a combined legend for both line and column values by ensuring each series comes from a distinct measure.
- Select the Line and Clustered Column chart visual.
- Create separate measures for each data point .
- Add one measure to Column Values and the other to Line Values.
- Power BI will automatically generate a combined legend representing both series.
While this doesn’t provide separate legends for each, it ensures that both categories appear in the legend.
For more details, please refer to the official documentation attached.
Combo chart in Power BI - Power BI | Microsoft Learn
FYI:
If my response solved your query, please mark it as the Accepted solution to help others find it easily. And if my answer was helpful, I'd really appreciate a 'Kudos'.
Hi KripaShankar ,
Yeah, this one can be a bit tricky. The default Line and Column chart in Power BI only shows one legend — usually for the line values. If you want to show legends for both line and column series, here are a couple of workarounds:
Use a combo chart
Create a Line and Clustered Column chart. Then, make sure each value (line and column) is coming from a different measure. Power BI will show a combined legend for both.Use a stacked column instead
If your column values can be stacked, switching to a stacked column + line chart sometimes helps with better legend control.Manual legend using shapes/text
If nothing works, you can manually add a legend using text boxes and colored shapes. Not ideal, but works for static reports.
Hope this helps!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI