Forum Discussion

KripaShankar's avatar
KripaShankar
New Member
1 year ago
Solved

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
  • danextian's avatar
    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.

     

     

  • V-yubandi-msft's avatar
    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. 

    1. Select the Line and Clustered Column chart visual. 
    2. Create separate measures for each data point . 
    3. Add one measure to Column Values and the other to Line Values.
    4. 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'.