Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AmitMoolya
Regular Visitor

scatter chart with line in between / dumbbell chart with multiple start and end for single ID.

Hello Team,

I want each series (identified by the ID) to be connected by lines. I know how to create a basic scatter plot, but I'm not sure how to connect the points with lines and ensure that each series is properly displayed. There are certain ID which has multiple start & end for single ID, line should end and end point and restart at start point.

 

Could anyone provide a step-by-step guide on how to achieve this in Power BI? Any tips on formatting and customization would also be greatly appreciated!

IDStartEnd
abc11
dqf4392
pqr11
pqr5758
lmn2020
stu1718
xyz3639

AmitMoolya_0-1720386491349.png
You can also refer one of the Spotfire dashabord from which we need to replicate this visual in power BI, refer below link:
"https://eu.spotfire-next.cloud.tibco.com/spotfire/wp/analysis?file=/Users/so7oeqf2n2qcxmgxhisgprucx...

Regards,
Amit Moolya

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @AmitMoolya ,

I create a table as you mentioned.

vyilongmsft_0-1720494078797.png

Then I put it into Dumbbell Bar Chart.

vyilongmsft_1-1720494373123.png

vyilongmsft_2-1720494460233.png

I think you can add Start into Legend.

vyilongmsft_3-1720494520960.png

vyilongmsft_4-1720494557582.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @AmitMoolya ,

I create a table as you mentioned.

vyilongmsft_0-1720494078797.png

Then I put it into Dumbbell Bar Chart.

vyilongmsft_1-1720494373123.png

vyilongmsft_2-1720494460233.png

I think you can add Start into Legend.

vyilongmsft_3-1720494520960.png

vyilongmsft_4-1720494557582.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AmitMoolya
Regular Visitor

This is not working, do we have any another option. 

here's an example

Deneb Workout 08 - Dumbbell Chart - Workouts / Deneb - Enterprise DNA Forum

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

lbendlin
Super User
Super User

 

one of the Spotfire dashabord from which we need to replicate this visual in power BI,

 

Out of curiosity - why do you think you need to replicate that?

 

Consider using Deneb visuals, they can create connected Scatter plots very easily.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors