Forum Discussion

Advocate II

9 years ago

Solved

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!

robingol
9 years ago
Hi

I had the same issue, you need to put the header on in the slicer formatting and the option is then available.
TaylorNathan
9 years ago
That's correct. Go into settings for the visual and make sure the "Header" is On (not to be confused with the Title setting).

Advocate I

9 years ago

Hi

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

TaylorNathan
Advocate II
9 years ago
That's correct. Go into settings for the visual and make sure the "Header" is On (not to be confused with the Title setting).
rodlovely
Regular Visitor
6 years ago
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
  Helper IV
  5 years ago
  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).
NinaJS
New Member
3 years ago
For me the solution was to put the field (I wanted to dropdown a year column) on don't summarize.
- Garfield_King
  New Member
  2 years ago
  Thanks , that solved my problems. saved my day

Related content