Add others options to TopN Filter

[muellera1995]

Add "Others" option to the current TopN feature. That would greatly advance user experience as it allows to compress the data set, highlight the most important insights (e.g. Top 5 Sales), but still gives an overview of all of the data.

[info253]

I face a similar request build into a dataset.

The solution always requires an calculated helper table to the selected attribute (TOPcustomers, TOPcustomergroups, TOPproducts, ect.) as well a pretty complex DAX. This is nothing, you can provide to "normal" users and well results in a lot of small tables in the datamodel and measures.

Furthermore, dataset refresh in composite datasets are not supported, is they contain calculated tables or columns. "Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery"

Therefore a solution would greatly appreciated, if the user can select the TOPx attributes plus an option to show others, based on the selected column attribute, which then calculates "others" in the visual (e.g. a column chart).

[avanausdall]

This would save me a ton of time as this is a frequently requested feature in many of our dashboards.

[par_adeen]

Tried to implement this with highlighting but that’s impossible to do generic. So please implement this in the visual domains