Forum Discussion
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 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.
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.
1 Reply
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.