Top N filter on Sankey Chart

[ram142more]

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

[rubayatyasmin]

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]

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.