Laura Collie on 22 Apr 2017 00:21:19
Top n Filter should be allowed on multiple fields and/or against multiple facts. For example - show top 10 sales people and lowest 10 products (both facts should be true to be displayed). As of April 2017, only one top n filter is allowed, so I'm exporting data to Excel for reporting.
Also, wish Excel could use my .pbix file as a data source for the PowerPivot data model - then i could easily work with any of the data (including all the measures). Power BI is a fantastic tool, but still needs Excel at times.
- Comments (99)
RE: Top n filter
The workaround mentioned above also only provides you a static ability to do this, which can yield unintuitive results when using filters on the graphs. This functionality has been requested multiple times by our users and each time we bashfully cannot provide them the simple functionality and analytics that so much of Power BI provides.
RE: Top n filter
rather surprised this was not part of initial build of TopN feature. This is basic functionality that is expected to be here. Many competing products simply have a check box to "include Others" as a category.
RE: Top n filter
Add an intuitive user interface within the chart value filters to show the top/bottom X values.
RE: Top n filter
Yes fully agree, PBI please add this feature to the Top N filter! This will allow users to create readable charts while still keeping totals the same.
RE: Top n filter
Yes this feature would be much appreciated! Similar to the Idea "Other" group in top N filter".
For me personally, just extending the Top N filter feature with the option to aggregate the rest as "other" would suffice and seems to be low effort to develop.
RE: Top n filter
This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.
Thanks.
There´s other 3 ideas like this one.
RE: Top n filter
Any advance on this feature?
RE: Top n filter
This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.
Thanks.
RE: Top n filter
Can you please add Top and Bottom N under the Filter Type for Visual level filters. This helps to see Top and Bottom N in one chart or grid?
RE: Top n filter
Currently, the number of bars or columns in bar or column charts displayed depends on the number of distinct values in the field used in the axis. We should have the option to display only top n and remaining should be grouped as others.