Epic idea: New list slicer

[Miguel_Myers]

To address the limitations of our current slicers, which are less advanced and potentially confusing compared to our competitors, a new and enhanced list and dropdown slicer should be designed with a wider range of customization options, incorporating industry best practices, and include innovative features like the ability to copy and paste lists.

[SMSmith1]

Come on Microsoft! The ability to paste a list of values into a slicer should be standard feature by now. We've been waiting for this for seven years. We need to be able to paste a list of values from Excel or Word, or Notepad into a slicer that also has the ability to SYNC across pages. Custom visuals Mass Filter and Filter By List used to provide this functionality but are currently broken from syncing across pages. We have thousands of users that need to paste lists of customer IDs or part numbers that are in the hundreds of values. There are several other suggestions out there too for the same capability.

PLEASE HELP. We are wasting so much time simply setting slicers.

[robert_hawke]

please prioritize dropdown mode for the new slicer. We use 90 % drop down slicers in our reports because they are the most space efficient.

please also ensure to merge this idea for the dropdown slicer

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=08d20ffa-7a99-ee11-a81c-000d3adc66b1

[jonathan4]

We're making great progress in data visualization, but sometimes, incredibly simple things remain unnecessarily complicated—and it's frustrating.

For example, my client wants to visually distinguish between applied and non-applied filters (filters on a page, not in the filter pane, where this would be easy). The new slicers could make this effortless… but dropdown lists are missing! With the old slicers, it's simply impossible.

I keep going in circles on such basic issues. @Miguel Myers, help!!! 😅

[Anonymous]

I have a list slicer with two levels of items. I just had a user ask for an item to be added that was already there. I had removed indentation to make fewer labels truncated, but it has the side-effect of making the groups less obvious. I'd like to remove the expand and collapse option completely to grant the labels even more space, and then format the top level items in a different way so they are clearly headers. Currently it seems everything gets the same format, whatever level it is on.

[kleigh]

Another multi-level issue: Some of my field parameters are getting rather chunky. Similar to my last post, adding a grouping level to them which can display as a header would help with this. However, it seems that at present even if you make the slicer single select, if you have multiple grouping levels you can select a higher level item and thereby select multiple lower level items. I need a "really single select" option that will only allow selection at the lowest level.

[RHOU]

@jonathan4 I have a workaround for that. it is annoying that it is necessary to go through so much extra work which also slows down report performance if you have a LOT of slicers, but it does work. 1) add your regular dropdown slicer and make sure the background is transparent 2) add a rectangle BELOW your drop down slicer and make it the size of the dropdown field. For this drop down slicer choose the background to be based on FX / Measure 3) The measures are quite simple: Slicer BG Account Name (CRM) = if(ISFILTERED(Accounts[Account Name (CRM)]), [Slicer Active BG Color], [Slicer Inactive BG Color]) Slicer Active BG Color = "#ebc0bc" Slicer Inactive BG Color = "#f6f7f8" It then looks like this. https://www.linkedin.com/feed/update/urn:li:activity:7156706323881938944/

[yamayancha]

Slicers should also have the option to show a pre-selection based on a measure, so that a report for example will always open on a specific date but the date can still be changed within the slicer

[Dmitrij-Jazikov]

Hi!  We are currently implementing Power BI (PPU license).  We love the idea of a new List Slicer - especially the ability to filter / paste multiple/hundreds of values. However, with many unique attribute values the new List Slicer becomes enormously slow - initially it always sorts values and gets 1st 500 values to show to the user. It takes 1 second for each of 2 mln. unique values to display. For the biggest dimension (>50 mln. values) it may take 25 seconds before the user is allowed to paste any list of values. It would be great if you could add some options to switch off the display of any initial filter values (e.g. just having drop-down sign/mark or some indication of the slicer having / not having filtered values). Then the visual would not spend any time on excessive DAX query execution - it would be able to accept hundreds of pasted values and quickly execute final DAX queries on the current page.  Currently only Filters -> Advanced filtering -> "is" avoids any initial list generation and provides the quickest way to apply filter values for the whole page. Unfortunately, it allows to paste only 2 unique values.