Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Slicer dropdown selection control

Is there any possibility to bring the slicer dropdown visubility as follows?

wireframe.jpg

When i drop year field in the slicer, i am getting the slicer dropdown as shown below.

year.jpg

But, I wanna show it as the first image.

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @Anonymous 

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

vangzhengmsft_0-1646705339570.png

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:

vangzhengmsft_1-1646705627886.png

 

 

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.

View solution in original post

4 REPLIES 4
v-angzheng-msft
Community Support
Community Support

Hi, @Anonymous 

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

vangzhengmsft_0-1646705339570.png

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:

vangzhengmsft_1-1646705627886.png

 

 

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
Solution Sage
Solution Sage

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
Not applicable

Yes, currently i put single selection only.

@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 😀

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.