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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors