Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer dropdown selection control

Is there any possibility to bring the slicer dropdown visubility as follows? When i drop year field in the slicer, i am getting the slicer dropdown as shown below. But, I wanna show it ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    So you want to implement from Figure 1 to Figure 2, in order to avoid selecting a year by default.

    Solution:

    Click on the slicer, under the selection control options turn off Single select and turn on Multi-select with CTRL
    This way you won't get the default selection value and you select the value directly on the slicer, the slicer will be Single-select.

     

    Result:

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jaideepnema's avatar
jaideepnema
Solution Sage
4 years ago

Hi Anonymous ,

Have you tried enabling single selection for a slicer ? go to format Visual-> slicer settings->selection and enable single selection.

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos ğŸ˜€

 

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes, currently i put single selection only.

  • jaideepnema's avatar
    jaideepnema
    Solution Sage
    4 years ago

    Anonymous ,

    As per my understanding you cannot format a slicer in this way.  You can add an idea for this :Ideas (powerbi.com)

     

    Alternatively you can also try using https://okviz.com/smart-filter/ custom visual.

     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€