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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sankey Diagram four pillars

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_BezitOBJECTIDPMEOBJECT
Object Type IDDIM_BezitOBJECTTYPEPMEOBJECT
Object Type DIM_BezitENUMITEMLABELMRENUMS_OBJECTTYPE
Gebouw ID DIM_BezitBUILDINGIDPMEOBJECT
Gebouw  DIM_BezitNAMEPMEBUILDING
Kavel ID DIM_BezitGROUNDIDPMEOBJECT
Kavel  DIM_BezitGROUNDIDPMEGROUND
Land  DIM_BezitNAMEADDRESSCOUNTRYREGION
Rayon  DIM_BezitNAMEPMETYPE_REGION
Provincie  DIM_BezitNAMEADDRESSSTATE
Gemeente  DIM_BezitNAMEADDRESSCOUNTY
Woonplaats  DIM_BezitCITYPMEBUILDING
Postcode  DIM_BezitZIPCODEPMEBUILDING
Straat + HuisnummerDIM_BezitSTREETPMEBUILDING
Huisnummer  DIM_BezitHOUSENUMBERPMEBUILDING
Huisnummer Toevoeging DIM_BezitHOUSENUMBERADDITIONPMEBUILDING
Wijk  DIM_BezitDESCRIPTIONPMEDISTRICTTABLE
Buurt  DIM_BezitDESCRIPTIONPMENEIGHBORHOODTABLE
CBS-Wijk  DIM_BezitDISTRICTDESCRIPTIONPMECBSDISTRICTTABLE
CBS-Buurt  DIM_BezitCBSNEIGHBOURHOODDESCRIPTIONPMECBSNEIGHBOURHOODTABLE
Adres  DIM_BezitADDRESSPMEBUILDING
VGO Adres DIM_BezitADDRESSPMCCONTRACTOBJECT
Ligging  DIM_BezitNAMEPMETYPE_LOCATION
Financieel Complex DIM_BezitFINANCIALCOMPLEXPMEFINANCIALCOMPLEXTABLE

 

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:

Afbeeldingsresultaat voor sankey diagram power bi

9 REPLIES 9
rroche
Regular Visitor

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

pagaczpagacz
Frequent Visitor

Hi, try with simple sample.

 

Create ONLY two columns:

 

  • Source; Destination

then fill rows with simple connection data eg.

 

  1. first row Source column: A ; Destination column: B
  2. 2nd row Source: B ; Destination: C
  3. 3rd row Source: ; Destination: C
  4. Source: ; Destination: D
  5. B ; D
  6. A ; D
  7. 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
Not applicable

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?

2018-12-16.png

 

SourceDestination
Object ID DIM_Bezit
Object Type IDDIM_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 + HuisnummerDIM_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_BezitOBJECTID
DIM_BezitOBJECTTYPE
DIM_BezitENUMITEMLABEL
DIM_BezitBUILDINGID
DIM_BezitNAME
DIM_BezitGROUNDID
DIM_BezitGROUNDID
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitCITY
DIM_BezitZIPCODE
DIM_BezitSTREET
DIM_BezitHOUSENUMBER
DIM_BezitHOUSENUMBERADDITION
DIM_BezitDESCRIPTION
DIM_BezitDESCRIPTION
DIM_BezitDISTRICTDESCRIPTION
DIM_BezitCBSNEIGHBOURHOODDESCRIPTION
DIM_BezitADDRESS
DIM_BezitADDRESS
DIM_BezitNAME
DIM_BezitFINANCIALCOMPLEX
OBJECTIDPMEOBJECT
OBJECTTYPEPMEOBJECT
ENUMITEMLABELMRENUMS_OBJECTTYPE
BUILDINGIDPMEOBJECT
NAMEPMEBUILDING
GROUNDIDPMEOBJECT
GROUNDIDPMEGROUND
NAMEADDRESSCOUNTRYREGION
NAMEPMETYPE_REGION
NAMEADDRESSSTATE
NAMEADDRESSCOUNTY
CITYPMEBUILDING
ZIPCODEPMEBUILDING
STREETPMEBUILDING
HOUSENUMBERPMEBUILDING
HOUSENUMBERADDITIONPMEBUILDING
DESCRIPTIONPMEDISTRICTTABLE
DESCRIPTIONPMENEIGHBORHOODTABLE
DISTRICTDESCRIPTIONPMECBSDISTRICTTABLE
CBSNEIGHBOURHOODDESCRIPTIONPMECBSNEIGHBOURHOODTABLE
ADDRESSPMEBUILDING
ADDRESSPMCCONTRACTOBJECT
NAMEPMETYPE_LOCATION
FINANCIALCOMPLEXPMEFINANCIALCOMPLEXTABLE
Anonymous
Not applicable

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

 

2018-12-16.png

 

SourceDestination
Object ID DIM_Bezit
Object Type IDDIM_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 + HuisnummerDIM_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_BezitOBJECTID
DIM_BezitOBJECTTYPE
DIM_BezitENUMITEMLABEL
DIM_BezitBUILDINGID
DIM_BezitNAME
DIM_BezitGROUNDID
DIM_BezitGROUNDID
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitNAME
DIM_BezitCITY
DIM_BezitZIPCODE
DIM_BezitSTREET
DIM_BezitHOUSENUMBER
DIM_BezitHOUSENUMBERADDITION
DIM_BezitDESCRIPTION
DIM_BezitDESCRIPTION
DIM_BezitDISTRICTDESCRIPTION
DIM_BezitCBSNEIGHBOURHOODDESCRIPTION
DIM_BezitADDRESS
DIM_BezitADDRESS
DIM_BezitNAME
DIM_BezitFINANCIALCOMPLEX
OBJECTIDPMEOBJECT
OBJECTTYPEPMEOBJECT
ENUMITEMLABELMRENUMS_OBJECTTYPE
BUILDINGIDPMEOBJECT
NAMEPMEBUILDING
GROUNDIDPMEOBJECT
GROUNDIDPMEGROUND
NAMEADDRESSCOUNTRYREGION
NAMEPMETYPE_REGION
NAMEADDRESSSTATE
NAMEADDRESSCOUNTY
CITYPMEBUILDING
ZIPCODEPMEBUILDING
STREETPMEBUILDING
HOUSENUMBERPMEBUILDING
HOUSENUMBERADDITIONPMEBUILDING
DESCRIPTIONPMEDISTRICTTABLE
DESCRIPTIONPMENEIGHBORHOODTABLE
DISTRICTDESCRIPTIONPMECBSDISTRICTTABLE
CBSNEIGHBOURHOODDESCRIPTIONPMECBSNEIGHBOURHOODTABLE
ADDRESSPMEBUILDING
ADDRESSPMCCONTRACTOBJECT
NAMEPMETYPE_LOCATION
FINANCIALCOMPLEXPMEFINANCIALCOMPLEXTABLE
v-chuncz-msft
Community Support
Community Support

@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.
Anonymous
Not applicable

Hey Sam,

 

 

Today i tried it however i am not getting the right result.

Any idea's on what i am doing wrong?

 

 

 

Knipsel

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.