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

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

Reply
DanielGilbey
Frequent Visitor

Having a challenge with a Sankey chart - please help

Hi all, thanks in advance for any help/guidance with this. 

I posted before about wanting to track a pathway over time and (wrongly) assumed that simply using the Sankey visualisation I would get what I needed - you can see that post here > https://community.fabric.microsoft.com/t5/Desktop/How-to-chart-changes-over-time-from-one-item-to-an... 

 

I'm having trouble with the summarise function (which I believe is necessary) to give me a three level flow and that I need somehow to make a count of the Via column to do this?

 

Example data below and I'm keen to chart the volume of A to B to C points to show totals of From flowing into Totals of Via flowing into Totals of To

 

FromViaTo
ParisAmsterdamShanghai
ParisFrankfurtSingapore
ParisFrankfurtSingapore
ParisDubaiNew York
ParisIstanbulShanghai
ParisHornbillSingapore
MilanAmsterdamNew York
MilanAmsterdamNew York
MilanIstanbulNew York
MilanFrankfurtShanghai
MilanFrankfurtSingapore
LondonFrankfurtSingapore
LondonFrankfurtShanghai
LondonAmsterdamSingapore
LondonAmsterdamShanghai

 

The closest I can find on the forum is this post - https://community.fabric.microsoft.com/t5/Desktop/How-to-create-multi-level-sankey-diagram-Sankey-vi... but for the life of me, I can't seem to get it to work..! I keep getting the below type 'map' which isn't as expected. I'm trying to get that 'simple' 3 step flow... Please send help!! 

DanielGilbey_0-1691740149367.png

 

1 REPLY 1
DanielGilbey
Frequent Visitor

Just to add to this, I have a distinct additional column that would go with this (in this example it could be names of the travellers (all unique))

I'm getting closer to the desired outcome (but still some way to go) so if anyone does have an idea or pointers, these would be greatly received! 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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