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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

8 REPLIES 8
marshala112
New Member

Hi so i've got the diagram i want.  but it want to show the Values and the source / destination name.  The data is in the tool tip.  but is there really no way to show the number?  I can't be the only person who wants a number in the component bars or in the flows?    I need to show these sankey's in Powepoint and don't want to have to manually write in the values.   please help 

@marshala112 Unfortunately, I'm running into the same problem!

So far found a way to do it via charticulator OR Deneb.

I created Idea for it:

https://community.fabric.microsoft.com/t5/Custom-Visuals-Ideas/Sankey-diagram/idi-p/3440502#M1193

You can vote for it.

technolog
Super User
Super User

@technolog  Yes, I saw that there's now an option toggle to determine how to handle looping. 🙂


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

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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

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.

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors