Forum Discussion

ram142more's avatar
ram142more
Frequent Visitor
3 years ago

Top N filter on Sankey Chart

Dear Members,

I have top N slicer in visual and need to apply same top N filter on "Sankey Chart" but it is not working for Sankey chart correctly.
Can, anyone will suggest me how we can manage to show only top categories in Sankey chart!! @all

 

Tips and Tricks

2 Replies

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi, ram142more 

     

    use RANKX. 

    for example.

    Rank Measure = RANKX(ALL('CategoryTable'), [AggregatedValue], , DESC)

     

    Add the rank measure to the "Filters" section of the Sankey chart visual, and set the filter condition to show only the top N ranks. For example, if you want to show the top 10 categories, set the filter condition to "Rank Measure <= 10".

     

    • ram142more's avatar
      ram142more
      Frequent Visitor
      3 years ago

      Thanks rubayatyasmin  for the quick solution.
      However, i am looking for dynamic solution like user can enter the number in slicer and accordingly it will show in Sankey Chart.