TOP N Filter in the slicer visualization

[wilberk]

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 not want to use the top N filter there because users will not see it once published. 

I have attached a screenshot highlighting in yellow that I need to have the filters pane hidden so do not want to do a top N filter by the way of the red X. I want to give users a filter such as circled in the blue for them to put whatever number they would like and get the top list based on that user inputed number. 

[meeen-ware · Accepted solution]

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.