Sankey Chart or Equivalent Solutions

[ExcelMonke]

Hi all,

I am trying to visualise data in a Sankey Chart (or similar like Chord/Tassels) that:

1. Shows Requesting Departments, and Receiving Departments
2. Is weighted by the amount of requests
3. Has the functionality of filtering to top N requesting departments AND keeping the equivalent amount of receiving departments
   1. Being able to filter it vice versa

Ideally, the intended result would have an equal N amount of requesting and receiving departments on each side. 

An example in tabular format for top N:

Total requests: 120
Top N: 5

Requesting Department	Requests	Receiving Department
ABC	40	DEF
DEF	30	PQR
GHI	11	STU
JKL	9	ABC
MNO	5	GHI

Remaining requests not shown: 25

Hopefully this makes sense!

[Anonymous · Accepted solution]

Hi @ExcelMonke ,

Please have a try.

Create a measure.

Top N Requesting Departments = 
     VAR TopNValue = 5
     RETURN IF(RANKX(ALL('YourTable'[Requesting Department]), CALCULATE(SUM('YourTable'[Requests])), , DESC) <= TopNValue, SUM('YourTable'[Requests]))

Power BI does not have a native Sankey Chart, but you can add one from the Power BI Visuals Marketplace. To keep an equal number of requesting and receiving departments, you may need to create a similar measure for the receiving departments and apply it as a filter as well.Add slicers to your report to allow users to dynamically select the top N departments.You can also use the built-in filter pane to allow users to filter the data interactively.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.