Top N filter hidden not removed

[DanielClark]

Hi,

It appears that there is an issue with the display of Filters when for example,

1. Top N filter has been applied,
2. Advanced Filtering has been selected from the drop down
3. The collapsed filter will show (All) when the table it is actually filtered to Top N

Regards,

[DanielClark · Accepted solution]

The issue has now been resolved (on web);

When a filter is applied it will display in the filter even if you change the selected filter type.

Happy days!

[v-huizhn-msft]

Hi @DanielClark,

After review your description, I still have some information needed to confirm.

1. You add the Top N filter in 'Visual level filters'? You add Advanced Filtering in  'Visual level filters'(highlighted red line) or 'Page level filters'(yellow background)?

2. TopN and Advanced Filtering are selected in different fields, right? Because one field only can use one Filter Type.

3.>>The collapsed filter will show (All) when the table it is actually filtered to Top N

  
When you add filter on report, it returns all rows without filter? Could you please share more details or screenshot for further analysis?

Best Regards,
Angelia 

[DanielClark]

Hi,

Any further info on this, did you need anything more from me to help?

Regards,

[v-huizhn-msft]

Hi @DanielClark,

Your issue is that the report still return all rather than blank, even if the advanced filter is blank and a Top N filter is set. As I tested, it works fine.



For your issue, it's weird, it works fine in Power BI desktop? could you please share your .pbix file for further analysis? 

Best Regards,
Angelia

[DanielClark]

Hi Angelia,

No, my issue is that the report will be filtered by Top N, even when the Filters section displays <Coulmn Name> (All), the Top N filter is hidden, this makes it confusing for me and other users.

Swtich Filter Type, but do not remove the filter:

There must be a better way to visualise this or at aleast show there is a filter in the background. Maybe this should be posted in the Ideas section of the community not here?

Regards,

[DanielClark]

Opened a ticket with Microsoft / Mindtree support as well:

1. When a Top N filter is selected {PowerBI Report Filters on}
2. The filter is collapsed the {PowerBI Report Filters on - Top N} filter is shown.
3. If the Selected Option is changed to Advanced Filter {PowerBI Report Filters on - Advanced selected}
4. Even if the advanced filter is blank and a Top N filter is set, the collapsed filter will show Url (All) {PowerBI Report Filters on - Advanced selected Top N hidden}