Slicer drop down

[EZgrafton]

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!

 

[robingol · Accepted solution]

Hi

I had the same issue, you need to put the header on in the slicer formatting and the option is then available.

[AnneKamanzi]

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.

[robingol · Accepted solution]

Hi

I had the same issue, you need to put the header on in the slicer formatting and the option is then available.

[rodlovely]

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.

[Alex_Ooi]

@rodlovely yeah, thank God for the forum. I just discovered this too, after using Power BI for close to 2 years. It does not make any sense at all - turning it on, and later off again (because I am using Title instead of Header Name).

[TaylorNathan · Accepted solution]

That's correct.  Go into settings for the visual and make sure the "Header" is On (not to be confused with the Title setting).

[robingol]

Hi,

I have the same problem and hovering over the slicer doesn't show the drop down option.

[Netope]

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

[jcarville]

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?

[Anonymous]

I just ran into the same issue - working on desktop and can't change my slicer to a dropdown.

[Anonymous]

I just downloaded the Oct version of PBI desktop and now I'm able to change the slicer 🙂

[jcarville]

@Anonymous  am also using the October version: 2.74.5619.862 64-bit (October 2019).

I created this report months ago. I created a new file as a test this morning and still can't switch between the date slicer types.

[robingol]

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.

[v-ljerr-msft]

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.

Regards