Forum Discussion

EZgrafton's avatar
EZgrafton
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's avatar
    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's avatar
    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).

     

robingol's avatar
robingol
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.

 

 

 

 

rodlovely's avatar
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's avatar
    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).