Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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
Hi, try with simple sample.
Create ONLY two columns:
then fill rows with simple connection data eg.
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
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?
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 |
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?
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 |
@Anonymous,
You may try adding calculated columns.
Column = Table1[new table] & "." & Table1[new column name]
Column 2 = Table1[old table] & "." & Table1[old column name]
Just use this approach
https://www.youtube.com/watch?v=K9uQD561F6Q
It's really work.
User | Count |
---|---|
84 | |
84 | |
68 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |