Forum Discussion

alicek's avatar
alicek
Icon for Helper III rankHelper III
5 years ago
Solved

How to make a slicer into a dropdown menu?

Hi all, 

 

Usually when I need to make a slicer into a drop down, instead of listing all options, I click on the three-dot menu in the corner and it offers me the option. However, it is not offering me that option anymore. 

 

Another post saying "you have to have the Header" feature turned on is out-of-date, because Header an oiptions anymore. I have both the Slicer Header and the Visual Header turned on. 

 

 

Does anyone know what could have caused this?

 

Thank you!

 

Need Help

15 Replies

  • emrson's avatar
    emrson
    New Member
    1 year ago

    what about when there are no 'options' in slicer settings?

    • justinhollis's avatar
      justinhollis
      New Member
      7 months ago

      I am hoping you figured this out but I will jsut put it here to maybe help someone else. I notices that the List Slicer, Text Slicer, and Button Slicers resrict this option. Make sure you choose the visual of a regular slicer before you add data to the widget. If you just select data the regular slicer is not an option and its kinda dumb/frustrating. 

      • Ihsene's avatar
        Ihsene
        New Member
        5 months ago

        This is super helpful, thank you so much.
        Here is a screenshot for those who are still lost 😉

         

  • powerfuj's avatar
    powerfuj
    New Member
    4 years ago

    Yes it is the little down arrow that is difficult to see. The arrow is associated with the Slicer Header.

    So you also need to have Slicer Header turned ON

    If the Slicer Header is OFF you will not see the little down arrow

    (I've just spent way too long figuring this out!)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi alicek 
    You have to click on the below icon to get it. 

    Select the slicer and hover over it. This icon will appear.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you so much!! I have been trying to figure this out and going nuts!!! You cannot see the darn carrot until you hover and then it blends in with the white background. Hopefully they will make this more apparent in the future.

  • alicek's avatar
    alicek
    Icon for Helper III rankHelper III
    5 years ago

    Wow, of course. It was so small on my screen I didn't see it. Thanks to you both!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Look for the three dots on the slicer and click on the Show as a table option.

    You'll see another three options on the top right of this new page.  There are two icons under the three options: the Clear Selection and Select the type of Slicer options.  This icon shows a list of slicer types.  

    Good luck.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      To switch on the slicer header, go to Format Visual in the Visualisations section and look for the Slicer header option.  Switch it on if it is off.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Does anyone have an answer? This is now different.  I get a little tool tip that says, "this setting has moved. To change the slicer style, select Format > Slicer settings > Options > Style."

     

     

     

    However, there is no such menu under Format. I only have "interactions" and "arrange"

     

     

     

    Help?

     

      • perfectreign's avatar
        perfectreign
        Frequent Visitor
        2 years ago

        Thank you all!  I am still getting used to the - in my opinion - confusing UI of PowerBI desktop.  I realized the settings are in teh Visualzations section.