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: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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 12
15,823 Views
0
11 REPLIES 11
MQaiserJaved
Helper I
Helper I

‎08-23-2024 05:26 AM

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

Message 12 of 12
1,184 Views
0
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 12
8,563 Views
0
technolog
Super User
Super User
In response to rroche

‎08-23-2024 05:37 AM

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
Message 11 of 12
1,180 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 12
15,781 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 12
15,773 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 12
15,758 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 12
15,753 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 12
15,736 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 12
15,802 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 12
15,793 Views
0

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

View All