Forum Discussion
Line and column - legend
I need to be able to include legend for both Line and Column values in a "Line and Column chart". How to get this work done?
Thanks,
Kripa
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.
Hi KripaShankar
It is not currently possible to use legends on both the line and column. Legend is supported on columns only.
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'.
7 Replies
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.
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 AIHi KripaShankar
It is not currently possible to use legends on both the line and column. Legend is supported on columns only.
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 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi KripaShankar ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi KripaShankar ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
