cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chris_1996
Helper I
Helper I

How to create multi-level sankey diagram. Sankey visual 3.0.3

I have tried to follow a few posts and videos on this but can't figure this out for the life of me. Data structure is very straight forward, however I want to have 3 sets of pillars. Can't figure this out.. Do i need to set up particular measures/formulas? 

 

I want there to be.

Pillar 1: Non-Australia Sources: Flow of volume from non-australian countries to australia

Middle Pillar 2: Australia destinations: Flow of volume from non-australian countries to Australia.

Pilalr 3 (on right): Non-Australia destinations: Flow of volume from australia to non-australia countries.

 

I'm using the custom visual Sankey 3.0.3 on PBI.

 

Data example:

SourceDestinationVolume
USAAustralia50
CanadaAustralia100
AustraliaNew Zealand30
AustraliaFiji80
   
1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @Chris_1996 

 

I attribute it to the design of the chart itself. When there is a loop in the data flow, the design of the chart makes the above display result. Although it looks a bit confusing, it clearly shows the loop flow of the data.
Okay, let's talk about making the chart look what we want.
According to my research, when the weight field is not put in the chart, the chart looks great.
When there is no loop in the data flow, the graph looks exactly what we want. For example, changing the flow from Australia to the USA to Australia to Singapore breaks the circular flow of the data.
When the inflow and outflow of data are equal, we can also get a look similar to what we want. Although there is a little trick here, it is to put the destination field in the source bucket and the source field in the destination bucket. I'm not sure why, but it works.

vangzhengmsft_0-1629967377358.png

The above is a possible effective solution to get the desired chart. Hope it helps you.

 

Please refer to the attachment below for details

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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
v-angzheng-msft
Community Support
Community Support

Hi, @Chris_1996 

 

I attribute it to the design of the chart itself. When there is a loop in the data flow, the design of the chart makes the above display result. Although it looks a bit confusing, it clearly shows the loop flow of the data.
Okay, let's talk about making the chart look what we want.
According to my research, when the weight field is not put in the chart, the chart looks great.
When there is no loop in the data flow, the graph looks exactly what we want. For example, changing the flow from Australia to the USA to Australia to Singapore breaks the circular flow of the data.
When the inflow and outflow of data are equal, we can also get a look similar to what we want. Although there is a little trick here, it is to put the destination field in the source bucket and the source field in the destination bucket. I'm not sure why, but it works.

vangzhengmsft_0-1629967377358.png

The above is a possible effective solution to get the desired chart. Hope it helps you.

 

Please refer to the attachment below for details

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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

Thanks - I will give this a go.

As a work around prior to this, I added a fullstop to the duplicate country in the destination column, that way it didn't recognize that it was the same input/output. But I will give what you have shown a go as it would be preferrable not to have the fullstop.

ie. 

SourceDestination
AustraliaUSA.
USAAustralia
AllisonKennedy
Super User
Super User

@Chris_1996  I'm not sure what you're looking for - this has the three pillars, with Australia in the middle. Can you draw what you want if this isn't it?

 

AllisonKennedy_0-1629339254714.png

https://excelwithallison.blogspot.com/2021/07/custom-visual-review-sankey.html 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Ok so this is exactly what i'm after. I think I realised why I wasn't able to get the visual to do what yours was showing and still would be great if you know a fix to this.

So this is the chart as per yours above:

Chris_1996_0-1629340709645.png

But i have instances where the source becomes the destination. ie. if we expand the original table so it looks like so: where i have added in a line that has volume going back from australia to usa. I want this line to be the same as the above chart, coming from australia in the middle row.. but it throws the visual into dissaray..

USAAustralia50
CanadaAustralia100
AustraliaNew Zealand30
AustraliaFiji80
AustraliaUSA20

This is the same visual as above, but with no filter applied on destination = USA.. Australia is no longer in the middle of the chart as i am after, and the chart is quite confusing.. Chris_1996_1-1629340818218.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.