Forum Discussion
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 t...
rubayatyasmin
Community Champion
Community ChampionHi, 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".
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.