Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Epic idea: New list slicer

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.

Status: Needs Votes
Comments
SMSmith1
New Member

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
New Member

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
New Member

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
Not applicable

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.

fbcideas_migusr
New Member
Status changed to: Needs Votes
 
kleigh
Resolver IV
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
Advocate III
@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/