How to create a Multi-Level Sankey Diagram in Microsoft Power BI | Power BI Custom Visuals

Anonymous · ‎12-11-2018

Hello,

I am trying to create a Sankey Diagram to give insight into the transformation i am making for my new DataModel.

However i do not seem to get the Sankey Diagram to work properly.

Object ID	DIM_Bezit	OBJECTID	PMEOBJECT
Object Type ID	DIM_Bezit	OBJECTTYPE	PMEOBJECT
Object Type	DIM_Bezit	ENUMITEMLABEL	MRENUMS_OBJECTTYPE
Gebouw ID	DIM_Bezit	BUILDINGID	PMEOBJECT
Gebouw	DIM_Bezit	NAME	PMEBUILDING
Kavel ID	DIM_Bezit	GROUNDID	PMEOBJECT
Kavel	DIM_Bezit	GROUNDID	PMEGROUND
Land	DIM_Bezit	NAME	ADDRESSCOUNTRYREGION
Rayon	DIM_Bezit	NAME	PMETYPE_REGION
Provincie	DIM_Bezit	NAME	ADDRESSSTATE
Gemeente	DIM_Bezit	NAME	ADDRESSCOUNTY
Woonplaats	DIM_Bezit	CITY	PMEBUILDING
Postcode	DIM_Bezit	ZIPCODE	PMEBUILDING
Straat + Huisnummer	DIM_Bezit	STREET	PMEBUILDING
Huisnummer	DIM_Bezit	HOUSENUMBER	PMEBUILDING
Huisnummer Toevoeging	DIM_Bezit	HOUSENUMBERADDITION	PMEBUILDING
Wijk	DIM_Bezit	DESCRIPTION	PMEDISTRICTTABLE
Buurt	DIM_Bezit	DESCRIPTION	PMENEIGHBORHOODTABLE
CBS-Wijk	DIM_Bezit	DISTRICTDESCRIPTION	PMECBSDISTRICTTABLE
CBS-Buurt	DIM_Bezit	CBSNEIGHBOURHOODDESCRIPTION	PMECBSNEIGHBOURHOODTABLE
Adres	DIM_Bezit	ADDRESS	PMEBUILDING
VGO Adres	DIM_Bezit	ADDRESS	PMCCONTRACTOBJECT
Ligging	DIM_Bezit	NAME	PMETYPE_LOCATION
Financieel Complex	DIM_Bezit	FINANCIALCOMPLEX	PMEFINANCIALCOMPLEXTABLE

This is an example of the data i am using,

Starts with the new column name, new table, old column name, old table.

Does anyone know how i could get it to where it is simar to:

MQaiserJaved · ‎08-23-2024

Hi,

Your data format is supported in Sankey Diagram by ChartExpo. This custom visual support tabular data format, no need to make source and target columns. As a refence you can check following:

How to create a Multi-Level Sankey Diagram in Microsoft Power BI | Power BI Custom Visuals

TIA

rroche · ‎03-08-2022

I have four pillars as well documenting the flow of data from one storage location to its final destination. How can I achieve four pillars in Power BI

technolog · ‎08-23-2024

You can choose any visual and do it. Don't understand question.

____________

⭐️ Fabric Group Channel

⭐️ Microsoft Fabric Community

Please join the Power BI UX/UI User Group if you need help with dashboard design and usability

Join to Data Governance User Group
Join to DENEB and Power BI Enthusiasts User Group
Join to Data Fabric Best Practices User Group
Subscribe to my medium blog

pagaczpagacz · ‎12-15-2018

Hi, try with simple sample.

Create ONLY two columns:

Source; Destination

then fill rows with simple connection data eg.

first row Source column: A ; Destination column: B
2nd row Source: B ; Destination: C
3rd row Source: A ; Destination: C
Source: C ; Destination: D
B ; D
A ; D
etc.; etc...

You will see 🙂

Then you can continue and create third column with "quantity" or "weight" and fill with small numbers.

Let me know if it's working.

ofc - remeber about refreshing your data source

Anonymous · ‎12-15-2018

Hey,

I am starting to feel really dumb but i am just not getting a third or fourth pillar.

It stays with only 2 but for me the get the correct display i need 4.

Does anyone know the logic behind this visual?

pagaczpagacz · ‎12-15-2018

Source	Destination
Object ID	DIM_Bezit
Object Type ID	DIM_Bezit
Object Type	DIM_Bezit
Gebouw ID	DIM_Bezit
Gebouw	DIM_Bezit
Kavel ID	DIM_Bezit
Kavel	DIM_Bezit
Land	DIM_Bezit
Rayon	DIM_Bezit
Provincie	DIM_Bezit
Gemeente	DIM_Bezit
Woonplaats	DIM_Bezit
Postcode	DIM_Bezit
Straat + Huisnummer	DIM_Bezit
Huisnummer	DIM_Bezit
Huisnummer Toevoeging	DIM_Bezit
Wijk	DIM_Bezit
Buurt	DIM_Bezit
CBS-Wijk	DIM_Bezit
CBS-Buurt	DIM_Bezit
Adres	DIM_Bezit
VGO Adres	DIM_Bezit
Ligging	DIM_Bezit
Financieel Complex	DIM_Bezit
DIM_Bezit	OBJECTID
DIM_Bezit	OBJECTTYPE
DIM_Bezit	ENUMITEMLABEL
DIM_Bezit	BUILDINGID
DIM_Bezit	NAME
DIM_Bezit	GROUNDID
DIM_Bezit	GROUNDID
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	CITY
DIM_Bezit	ZIPCODE
DIM_Bezit	STREET
DIM_Bezit	HOUSENUMBER
DIM_Bezit	HOUSENUMBERADDITION
DIM_Bezit	DESCRIPTION
DIM_Bezit	DESCRIPTION
DIM_Bezit	DISTRICTDESCRIPTION
DIM_Bezit	CBSNEIGHBOURHOODDESCRIPTION
DIM_Bezit	ADDRESS
DIM_Bezit	ADDRESS
DIM_Bezit	NAME
DIM_Bezit	FINANCIALCOMPLEX
OBJECTID	PMEOBJECT
OBJECTTYPE	PMEOBJECT
ENUMITEMLABEL	MRENUMS_OBJECTTYPE
BUILDINGID	PMEOBJECT
NAME	PMEBUILDING
GROUNDID	PMEOBJECT
GROUNDID	PMEGROUND
NAME	ADDRESSCOUNTRYREGION
NAME	PMETYPE_REGION
NAME	ADDRESSSTATE
NAME	ADDRESSCOUNTY
CITY	PMEBUILDING
ZIPCODE	PMEBUILDING
STREET	PMEBUILDING
HOUSENUMBER	PMEBUILDING
HOUSENUMBERADDITION	PMEBUILDING
DESCRIPTION	PMEDISTRICTTABLE
DESCRIPTION	PMENEIGHBORHOODTABLE
DISTRICTDESCRIPTION	PMECBSDISTRICTTABLE
CBSNEIGHBOURHOODDESCRIPTION	PMECBSNEIGHBOURHOODTABLE
ADDRESS	PMEBUILDING
ADDRESS	PMCCONTRACTOBJECT
NAME	PMETYPE_LOCATION
FINANCIALCOMPLEX	PMEFINANCIALCOMPLEXTABLE

Anonymous · ‎12-15-2018

Hey,

I finnaly get the concept.

Was able te recreate it with another example.

Thank you!

Now i am able to create it in Excel and then upload the data to PowerBI.

Any idea's on how to create it in power bi?

pagaczpagacz · ‎12-15-2018

not necessary 🙂

send me screen of your data source and sankey conected with this data

Source	Destination
Object ID	DIM_Bezit
Object Type ID	DIM_Bezit
Object Type	DIM_Bezit
Gebouw ID	DIM_Bezit
Gebouw	DIM_Bezit
Kavel ID	DIM_Bezit
Kavel	DIM_Bezit
Land	DIM_Bezit
Rayon	DIM_Bezit
Provincie	DIM_Bezit
Gemeente	DIM_Bezit
Woonplaats	DIM_Bezit
Postcode	DIM_Bezit
Straat + Huisnummer	DIM_Bezit
Huisnummer	DIM_Bezit
Huisnummer Toevoeging	DIM_Bezit
Wijk	DIM_Bezit
Buurt	DIM_Bezit
CBS-Wijk	DIM_Bezit
CBS-Buurt	DIM_Bezit
Adres	DIM_Bezit
VGO Adres	DIM_Bezit
Ligging	DIM_Bezit
Financieel Complex	DIM_Bezit
DIM_Bezit	OBJECTID
DIM_Bezit	OBJECTTYPE
DIM_Bezit	ENUMITEMLABEL
DIM_Bezit	BUILDINGID
DIM_Bezit	NAME
DIM_Bezit	GROUNDID
DIM_Bezit	GROUNDID
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	NAME
DIM_Bezit	CITY
DIM_Bezit	ZIPCODE
DIM_Bezit	STREET
DIM_Bezit	HOUSENUMBER
DIM_Bezit	HOUSENUMBERADDITION
DIM_Bezit	DESCRIPTION
DIM_Bezit	DESCRIPTION
DIM_Bezit	DISTRICTDESCRIPTION
DIM_Bezit	CBSNEIGHBOURHOODDESCRIPTION
DIM_Bezit	ADDRESS
DIM_Bezit	ADDRESS
DIM_Bezit	NAME
DIM_Bezit	FINANCIALCOMPLEX
OBJECTID	PMEOBJECT
OBJECTTYPE	PMEOBJECT
ENUMITEMLABEL	MRENUMS_OBJECTTYPE
BUILDINGID	PMEOBJECT
NAME	PMEBUILDING
GROUNDID	PMEOBJECT
GROUNDID	PMEGROUND
NAME	ADDRESSCOUNTRYREGION
NAME	PMETYPE_REGION
NAME	ADDRESSSTATE
NAME	ADDRESSCOUNTY
CITY	PMEBUILDING
ZIPCODE	PMEBUILDING
STREET	PMEBUILDING
HOUSENUMBER	PMEBUILDING
HOUSENUMBERADDITION	PMEBUILDING
DESCRIPTION	PMEDISTRICTTABLE
DESCRIPTION	PMENEIGHBORHOODTABLE
DISTRICTDESCRIPTION	PMECBSDISTRICTTABLE
CBSNEIGHBOURHOODDESCRIPTION	PMECBSNEIGHBOURHOODTABLE
ADDRESS	PMEBUILDING
ADDRESS	PMCCONTRACTOBJECT
NAME	PMETYPE_LOCATION
FINANCIALCOMPLEX	PMEFINANCIALCOMPLEXTABLE

v-chuncz-msft · ‎12-12-2018

@Anonymous,

You may try adding calculated columns.

Column =
Table1[new table] & "."
    & Table1[new column name]

Column 2 =
Table1[old table] & "."
    & Table1[old column name]

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.