Forum Discussion

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

Sankey Chart or Equivalent Solutions

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   
ABC40DEF
DEF30PQR
GHI11STU
JKL9ABC
MNO5GHI

 

Remaining requests not shown: 25

Hopefully this makes sense!

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.