Forum Discussion
Clearing Top N Visual Filter
I guess the best option for you is to add bookmarks for different data fields. With bookmarks, you do not clear the filter, instead you just selected corresponding bookmark and change the N value. This workaround may not convenient if you have many field you want to rank by as you need to create a bookmark for each of them.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
johnsauber , Not sure how are you getting and using n.
Say you have param for that
measure =
var _m = if(isfiltered(param[param]), selectedvalue(param[param]), 10 )
return
// TOPN code
// use _m
@amitchandak Thank you for your reply. I'm adding a filter bucket to the visual on the filters pane by dragging a field there. From that filter box, you can choose filter type, selecting the Top N option. If you clear the filter on the published version of the report using that little eraser button, it indeed clears the filter and there is no recovering it once this has happened because in the published report, one cannot select a field upon which to calculated the Top N: it's simply not an option. This is like a hole you can fall into, but cannot climb out of.
Shown in the Desktop Version
After the filter criteria has been cleared, it cannot be reset (because you can't drage a data field to the By Value area, as shown in the web screenshot below:
I recognize that you can select the option to reset all visual (below), but then this puts the Top N in the filter with some arbitrary value that must be chosen upon publication. There isn't a good way to toggle between removing the top N and adding it back without resetting your filters and views on the entire report.
