Forum Discussion

PBI_2K26's avatar
PBI_2K26
Frequent Visitor
2 months ago
Solved

Multiple line and clustered columns chart

Hello community,

 

Is there a way to display multiple lines in the "Line and clustered column chart"?

 

Thank you.

  • hi PBI_2K26 

     

    To the best of my knowledge, this isn't possible using the native visual. You could try a third-party visual from the Visuals marketplace, as you may be able to find one that supports this functionality. Alternatively, you could use Deneb, which allows you to create virtually any custom visual you need.

    I've attached a sample deneb visual I have created that includes legends for both the lines and the columns for your reference.

     

     

7 Replies

  • Rupa01's avatar
    Rupa01
    Icon for Solution Sage rankSolution Sage

    Hi PBI_2K26,

    Yes - We can have multiple lines in "Line and Clustered Column Chart".

    Add one or more required fields or measures to Line Y-axis then you will have multiple lines in the chart.

     

    Check below example - 

     

     

    πŸ’‘ Helpful? Give a Kudos πŸ‘ β€” keep the community growing
    βœ… Solved your issue? Mark as Solution βœ”οΈ β€” help others find it faster

    Best regards,
    Rupasree Achari | BI & Fabric Analytics Engineer 
  • PBI_2K26's avatar
    PBI_2K26
    Frequent Visitor

    Hello,

    Thank you for your replies, but I have a specific point to clarify.

    I'm using legend to dynamically split the columns (have as many columns as legends)

    I would like to have the same result for the line chart (split lines by legends)

    Is that possible?

    • kushanNa's avatar
      kushanNa
      Icon for Super User rankSuper User

      hi PBI_2K26 

       

      To the best of my knowledge, this isn't possible using the native visual. You could try a third-party visual from the Visuals marketplace, as you may be able to find one that supports this functionality. Alternatively, you could use Deneb, which allows you to create virtually any custom visual you need.

      I've attached a sample deneb visual I have created that includes legends for both the lines and the columns for your reference.

       

       

    • Rupa01's avatar
      Rupa01
      Icon for Solution Sage rankSolution Sage

      PBI_2K26, Currently in the native PBI visual (Line and Clustered Column Chart), we only have column legend and line legend is not available to split the lines dynamically. Workaround to achieve this is by using Deneb Custome Visual.

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support

        Hi PBI_2K26 

        We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.