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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ScottJW
New Member

Sankey Diagrams in Power BI Service

Hello team,

 

I am trying to create Sankey Diagram in Power BI Service. 

 

Here is the sample data

 

SourceRevenueExpenses & ProfitDepartmentsCategoriesAmount
ServicesRevenueExpensesManagerialTraining Sessions           10,000
ServicesRevenueExpensesManagerialOffice rental           16,000
ServicesRevenueExpensesManagerialWages             9,400
ServicesRevenueExpensesCommercialWages           11,300
Product SalesRevenueExpensesCommercialTravel allowance           10,000
Product SalesRevenueExpensesCommercialAdvertising           12,000
Product SalesRevenueExpensesProductionMaterial Payment           25,000
Product SalesRevenueExpensesProductionLoan Payment             8,500
Product SalesRevenueExpensesProductionWages           19,500
LoansRevenueGross Profit Taxes           11,000
LoansRevenueGross Profit Net Profit           13,000

 

I explored Microsoft Sankey diagram. It accepts data in a specific format. It means, i have to transform my data to what Sankey diagram accepts. Is there any easy way to do it which could accept the data in a tabular format as i shown above or if anyone can suggest any mechanism which i can use to automatically tranform my data to the format accepted by Microsoft Sankey Diagram?

 

Any help would be highly apcreciated.

 

Thanks

 

5 REPLIES 5
SmithParker
New Member

I recently encountered a similar issue and found a solution with this Power BI visual from the Microsoft Store.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/visio-chart.sankey_diagram_visiochart

jashraf
New Member

I was recently trying to figure out a similar kind of issue. I ended up with the following Power BI visual on Microsoft Store.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/polyvista1585910805469.sankey_diagram...

 

I hope it will help.

Hi jashraf,

Thank you for shairing your findings. i will give it a try and share how it goes.

 

 
collinq
Super User
Super User

Hi @ScottJW ,

 

TO convert your tabular format into the Sankey accepted format, you can unpivot your data.  And, you will probably have to aggregate the data as well...  but, the unpivot is your first step.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Hi Collinq,

Let me give it shot and see if it could work for me. Thank you for the support.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors