Sankey Chart or Equivalent Solutions

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.