Forum Discussion
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
Solution 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 - AnkitKukreja
Super User
- PBI_2K26Frequent 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
Super 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.
- v-aatheeque
Community 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.