Forum Discussion
Slicer drop down
Hi,
I just downloaded the Nov update; however, I cannot convert my slicers into a drop down list. The option is not available.
Please help!
Hi
I had the same issue, you need to put the header on in the slicer formatting and the option is then available.
That's correct. Go into settings for the visual and make sure the "Header" is On (not to be confused with the Title setting).
22 Replies
Hi
I had the same issue, you need to put the header on in the slicer formatting and the option is then available.
That's correct. Go into settings for the visual and make sure the "Header" is On (not to be confused with the Title setting).
This type of behavior drives me nuts. What kind of logic is behind turning on a totally unrelated feature to make another feature work properly? I spent over an hour trying to apply a 'less than or equal' capability in a slicer. All the online tutorials make it look so easy to simply choose the setting from a drop down list, but none said I needed to turn the Header on first. Ridiculous.
For me the solution was to put the field (I wanted to dropdown a year column) on don't summarize.
Thanks , that solved my problems. saved my day
Hi EZgrafton,
I have tested it on my side, and I can switch my Slicers Between List and Dropdown with the latest version of Power BI Desktop(2.41.4581.361 64-bit (November 2016)).
When hovering over a Slicer on the report, the option to switch between List and Dropdown will show up automatically.:smileyhappy:
Regards
Don't use filter, the drop down option is not there. Click on the icon that reads slicer when you hover over, this is under the visualisations section. The icon looks like a table with a filter on the bottom right. On the right corner of the slicer, it will prompt you to add type of sliver then select drop down. I hope this helps.
hi there! i was having the same issue and found a solution. when you click on the slicer in visualization go to format visuals > slicer settings > dropdown. That is how I found the dropdown option. I could not make it work in the 'format' tab as powerbi suggests.
Stange but there is no > slicer ettings > dropdown choice...
Hi,
I have the same problem and hovering over the slicer doesn't show the drop down option.
I have the same issue. I alredy upgraded Power BI Desktop to the latest version 2.74.5619.621 64-bit , and activate the Slicer Header but the problem remains.
I found a workaround, not so elegant but works. The lastes version now allows us to copy a visual from another Power BI file, so I copied a working dorpdown list slicer from another file to the new file where I have the issue. Then, I updated the field info and it worked.
As I said this is just a workaround, the issue still remains if I create a new slicer from visualition panel
Hoper this helps
I've just came across this issue myself today. I'm almost sure this feature was working before?
The dropdown selection appears in edit mode but when in read mode on the service the dropdown to change slicer type is not there? I have slicer header turned on.
Has anyone else came across this?
Hi
I have the same problem. Re-downloaded the November update and the problem persists, the drop down option isn't available even when hovering over the slicer.
Do this first!
I found that the little-arrow-below-the-3-dots (ellipsis), that shows the dropdown option, is more accessible (and more visible), BEFORE I have applied format-painter / done formatting on the slicer.
