Sankey Diagrams in Power BI Service

[ScottJW]

Hello team,

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

Here is the sample data

Source	Revenue	Expenses & Profit	Departments	Categories	Amount
Services	Revenue	Expenses	Managerial	Training Sessions	10,000
Services	Revenue	Expenses	Managerial	Office rental	16,000
Services	Revenue	Expenses	Managerial	Wages	9,400
Services	Revenue	Expenses	Commercial	Wages	11,300
Product Sales	Revenue	Expenses	Commercial	Travel allowance	10,000
Product Sales	Revenue	Expenses	Commercial	Advertising	12,000
Product Sales	Revenue	Expenses	Production	Material Payment	25,000
Product Sales	Revenue	Expenses	Production	Loan Payment	8,500
Product Sales	Revenue	Expenses	Production	Wages	19,500
Loans	Revenue	Gross Profit		Taxes	11,000
Loans	Revenue	Gross 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

[SmithParker]

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]

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.

[ScottJW]

Hi jashraf,

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

[collinq]

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.

[ScottJW]

Hi Collinq,

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