Forum Discussion

wilberk's avatar
wilberk
Frequent Visitor
2 years ago
Solved

TOP N Filter in the slicer visualization

Is there a way to have a top N filter in a slicer visualization so users can change the N variable to top 5, top 10, ect.  I need to keep the filter pane hidden when  I publish the dashboard so do...
  • meeen-ware's avatar
    2 years ago

    Yes, you can follow these instructions. I has worked great. Basically, create a new table with your top N values, create a RANK use your selected value as a limit, and create a measure using this rank.