How to use SANKEY Charts in Power BI // Beginners Guide to Power BI in 2020

In this video, we go through a step by step guide on how to use Sankey Charts in Power BI. It's a very powerful visualisation tool that I don't see a lot of people using, so in this video I cover how to start using it and how to transform your data so it's ready for consumption by the Sankey Diagram.

We also touch a little bit on two new DAX functions, UNION and SUMMARIZE.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[bms]

Finally! Someone who actually explains this... the amount of searching if have done for this simple thing...

[kayeiaramariedeocampo]

Been watching most of your videos to recap my power BI skills these past few days and will be very useful to my new job in March 2021. This chart is very useful in HR data! Thank you so much! Keep it up! Hoping to watch all your vids before my onboarding :D

[vinciallen-steward]

I've used the Sankey Chart before, but utilizing the 'UNION' is a game changer!!! <3 <3 Thanks, man!! This is awesome!

[elinavinni]

Haven't seen this diagram before, but definitely a great way of displaying the data!

[Acheiropoietos]

This is the best summary I have seen about creating a good Sankey diagram in Power BI

[MichaelRygaard]

Thank you finally some one who explained the why this works and not just fast type stuff

[seang]

My god this is SO much easier than the methods I was trying to create all of these funky conditional columns in my primary table. This man should be named patron saint of data nerds.

[kalimanx]

The video was very helpful. The presentation made something complicated very simple. Thank you.

[RobertHickey]

This video helped me a lot! Thanks. I'm now trying to figure out how to just add the weight values to the Sankey diagram.

[cshahed]

Wow. This is what I've been looking for a long time

[RegainMotivation]

thanks alot brother, this helped me alot in my project.

[mabu]

Great video, thanks! Is there a possibility to use tooltips for the links and the nodes?

[clmfurh]

Thank you for your informative and clear lessons. But I have one question about how to display a value and its percentage on weight at the same sankey if I have a value and percentage column on top of source and destination?

[Klisania_A]

Thanks for the great content shared here!
I have a question: The create year that I have in my dataset is from 2011 till 2022 but is randomly sorted in the diagram?
How can I sort it properly?
Thanks, liked and subscribed!

[esyang]

Very Helpful, I was able to create the Sankey . Is there a way to create filters for Sankey? e.g I want to see the flow for a month.
Thank you in advance

[sumquodsum]

Could benefit from picking up on other capabilities of the Sankey visualization - everybody seems to be focusing only on the initial data creation and then it's the end of the video

[alvaroaguilerabalbontin]

Amazing video! How can you apply a filter to change the Sankey diagram taking into consideration the structure of the table? I have tried to apply a segmented filter in the Sankey diagram but no effect takes place, do you know how to solve this?

[varshaponkshe]

From where can i get the dataset used here?

[DataAnalyticsPro]

Hi Fernan, great video! I am trying to find the link to the dataset used. Can you please help me out with that?

[dganalysis]

Great explanation. I had used it before, but hadn't added three layers, so will check it out.

One question, is there anyway to colour the connections?