on 14 Nov 2016 02:22:53
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.
Jeroen ter Heerdt (administrator) on 18 Apr 2022 20:22:12
We have considered this as part of other enhancements to filters but need more votes to prioritize it.
- Comments (50)
- Merged Idea (11)
RE: Add others options to TopN Filter
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).
RE: Add others options to TopN Filter
Voted. Will definitely be a great step forward for PBI
RE: Add others options to TopN Filter
Can't believe this is even something that needs votes. This is such an essential feature of any B.I. solution that if I were selecting a product it would be high on the list in a gap analysis, and possibly a deal breaker. So get on and add it in like every other provider has!
RE: Add others options to TopN Filter
This is a essential feature for bar and pie charts analysis.So, common guys, prioritize it!
RE: Add others options to TopN Filter
Ugh need this so badly! the work arounds are so difficult. This is something you can easily do in Tableau but PowerBI is still lacking.
RE: Add others options to TopN Filter
100% necessary!The current workaround solutions are too complex and do not work perfectly...This is an absolute necessity.Please consider introducing it.Thank you.
RE: Add others options to TopN Filter
Even better, add it to visuals like Pie Charts, Stacked Bars as a default. Let users adjust it right from the visual, like Zebra BI allow.
RE: Add others options to TopN Filter
This would be great to have - I have a report that needs this now!
RE: Add others options to TopN Filter
The Top N filter option in visuals should have a checkbox that allows you to dynamically display an "other" category that groups everything outside the Top N selection. Right now the workarounds require making extra tables and very non-performant measures for larger data models.
RE: Add others options to TopN Filter
This would be very helpful as you do not know the relation of top N to the rest of the grouping.