TopN functionality

[Anonymous]

October update has TopN functionality but it is not upto the mark.
Like how user can drag and drop the field / measure for TopN filter.
If user clear the filter then dragged field disappear, user can not add again measure again in filter section.
Could you please help me out here.

[Sean]

@Anonymous I don't like how they implemented this also.

They have this tried-and-true product - the Excel Power Pivot Table - why don't they get any ideas from it?

Select a Field in the Pivot Table =>click on the Field Header => Value Filters => Top N...

(In fact clicking the field header also gives you so many other options we need - such as sorting at EACH level)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees

[Anonymous]

@Sean, @Seth_C_Bauer - Sean I agree with you.. This is what I was asking about. If you clear the filter then "by Value" field is gone.

if user has read access then they cannot add it once again. also drag and drop is not easy for every user.

if we are giving them top N functionality then they dont want to add field again and again..

I think microsoft PBI team think about it again. I will open a support ticket and will update you.

[v-ljerr-msft]

Hi All,

I agree with you. I think it is better to use a dropdown box for the value selection in this scenario as Sean mentioned above. Could you also submit this request on Power BI Ideas? So that we can vote it up, and Power BI team will take good consideration about it and make this feature come sooner.

Regards

[Seth_C_Bauer]

@Anonymous Are you talking about end users in the Service?

As a report author in the Desktop you have all the functionality to add/remove the filter settings.
If you are talking about end users in the Service interacting with the report then I would consider that "by design"... I'm creating a visual on TopN based on the criteria I want the end user to use. The fact that they can interact with Filters doesn't mean I want them saving or modifying the report. If you want to do that, share via a Content Pack or give them access to the dataset to build their own.

If they removed the filter, they can navigate back to the dashboard and into the report again and it should reset to the original filter set.