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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. 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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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