Create Table Sankey Diagram

[Kat_00]

To filter a Sankey diagram, I manually created a table that assigns the successor nodes and predecessor nodes to each node in a Sankey diagram.  Unfortunately, such manual creation is error-prone and time-consuming. Is there a way to create such a table automatically in Power Query (or DAX)?

To give you a better idea of what exactly should be created, the following images are shown.

A section of the original table (from which the Sankey diagram was created):

Source	Destination
A: Bloomberg Anywhere	A: Euronext All Indices
A: Bloomberg Datalicense per Request	A: Markit EDM
A: Bloomberg Datalicense per Request	A: coreBanking
A: Markit EDM	A: Report System - Analytics
A: Markit EDM	A: Report System - Portfolio Analysis
A: Markit EDM	A: Report System - Management Information
A: coreBanking - Processor	A: Data Warehouse
A: coreBanking	A: coreBanking - Processor
A: coreBanking - Processor	A: Excelsior
A: Refinitiv Datascope Select	A: coreBanking
A: coreBanking - Processor	A: Data Warehouse
A: coreBanking	A: coreBanking - Processor
A: Excelsior	A: ClientCenter
A: coreBanking - Processor	A: Excelsior

A section of the table that I created manually. This table should contain all nodes from the sankey diagram in the node column. The successor column must not contain the end nodes (but the node itself) and the predecessor column must contain the start nodes (but the node itself).

node	successor	predecessor
A: coreBanking		A: Bloomberg Datalicense per Request
A: coreBanking	A: Data Warehouse
A: coreBanking	A: coreBanking	A: coreBanking
A: coreBanking	A: coreBanking - Processor
A: coreBanking	A: Excelsior
A: coreBanking		A: Refinitiv Datascope Select
A: coreBanking	A: Datamart Clover
A: coreBanking - Processor		A: Bloomberg Datalicense per Request
A: coreBanking - Processor	A: Data Warehouse
A: coreBanking - Processor		A: coreBanking
A: coreBanking - Processor	A: coreBanking - Processor	A: coreBanking - Processor
A: coreBanking - Processor	A: Excelsior
A: coreBanking - Processor		A: Refinitiv Datascope Select
A: coreBanking - Processor	A: Datamart Clover
A: Excelsior		A: Bloomberg Datalicense per Request
A: Excelsior		A: coreBanking
A: Excelsior		A: coreBanking - Processor
A: Excelsior	A: Excelsior	A: Excelsior
A: Excelsior		A: Refinitiv Datascope Select
A: Excelsior	A: Datamart Clover
A: Datamart Clover		A: Bloomberg Datalicense per Request
A: Datamart Clover		A: coreBanking
A: Datamart Clover		A: coreBanking - Processor
A: Datamart Clover		A: Excelsior
A: Datamart Clover		A: Refinitiv Datascope Select
A: Datamart Clover	A: Datamart Clover	A: Datamart Clover

The Sankey Diagram:

The Sankey diagram when I have filtered by “Datamat Clover”, for example

[Anonymous]

Hi @Kat_00 ,

May I ask if lbendlin's reply was helpful? If so could you please mark lbendlin's reply as solution so more users can find the answer quickly. Thanks!

Best Regards,
Dino Tao

[lbendlin]

To filter a Sankey diagram

Create a disconnected table with all node names. Use that to feed the slicer

Create a measure that checks if the source or destination matches the selected value

Use the measure as a visual filter in the Sankey.