Forum Discussion

DanielClark's avatar
DanielClark
Icon for Helper II rankHelper II
9 years ago
Solved

Top N filter hidden not removed

Hi,   It appears that there is an issue with the display of Filters when for example, Top N filter has been applied, Advanced Filtering has been selected from the drop down The collapsed filter...
Need Help
Show and Tell
  • DanielClark's avatar
    DanielClark
    9 years ago

    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's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
DanielClark
Icon for Helper II rankHelper II
9 years ago

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}