Forum Discussion
Helper IITop 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 will show (All) when the table it is actually filtered to Top N
Regards,
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!
6 Replies
v-huizhn-msftMicrosoft Employee
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
Opened a ticket with Microsoft / Mindtree support as well:
- When a Top N filter is selected {PowerBI Report Filters on}
- The filter is collapsed the {PowerBI Report Filters on - Top N} filter is shown.
- If the Selected Option is changed to Advanced Filter {PowerBI Report Filters on - Advanced selected}
- 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}
- 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
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!