Forum Discussion
Option To Exclude Item(s)
Hi,
I created a slicer that contains several hundred thousands of items and taking time to scroll through them.
Are there options not to use the slicer that I created but select several items and they will be excluded from the table?
Thanks...tksnota...
Hi Anonymous
To solve the problem, please implement Search function, so users can search and select the required item.Please post of not solve your requirement
3 Replies
Hi Anonymous
To solve the problem, please implement Search function, so users can search and select the required item.Please post of not solve your requirement
Anonymous
- Instead of using a slicer, you can add a filter pane to the report where you can add multiple fields (including the items). This allows users to select multiple items to include/exclude without the performance overhead of a slicer with hundreds of thousands of values.
- If you still want to use a slicer but with better performance, you can enable the search functionality within the slicer. This allows users to search for and select specific items. To exclude items, you could create a "Exclude Items" list and use DAX filters to exclude the selected items from the table.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
