Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Sankey Diagram four pillars

‎12-11-2018 01:55 AM

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

Labels:
Message 1 of 10
14,016 Views
0
9 REPLIES 9
rroche
Regular Visitor

‎03-08-2022 06:57 PM

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

Message 10 of 10
6,756 Views
0
pagaczpagacz
Frequent Visitor

‎12-15-2018 02:31 PM

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: A ; Destination: C
  4. Source: C ; 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

Message 5 of 10
13,974 Views
0
Anonymous
Not applicable
In response to pagaczpagacz

‎12-15-2018 03:16 PM

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?

Message 6 of 10
13,966 Views
0
pagaczpagacz
Frequent Visitor
In response to Anonymous

‎12-15-2018 03:43 PM

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
Message 8 of 10
13,951 Views
0
Anonymous
Not applicable
In response to pagaczpagacz

‎12-15-2018 04:10 PM

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?

Message 9 of 10
13,946 Views
0
pagaczpagacz
Frequent Visitor
In response to Anonymous

‎12-15-2018 03:19 PM

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
Message 7 of 10
13,929 Views
0
v-chuncz-msft
Community Support
Community Support

‎12-12-2018 01:04 AM

@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.
Message 2 of 10
13,995 Views
0
Anonymous
Not applicable
In response to v-chuncz-msft

‎12-15-2018 04:59 AM

Hey Sam,

 

 

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

Any idea's on what i am doing wrong?

 

 

 

Knipsel

 

 

 

Message 3 of 10
13,986 Views
0
technolog
Super User
Super User
In response to Anonymous

‎02-10-2023 02:02 AM

Just use this approach

https://www.youtube.com/watch?v=K9uQD561F6Q

It's really work.

technolog_0-1676023308800.png

 



____________
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
Message 4 of 10
3,203 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

View All