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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Make Radio Button functionality in Chiclet Slicer

I have the below chiclet slicer in my report to select the week days in it. As of now, we are able to select multiple values, however I am looking for a option to select only one day like a radio buttons. 

 

How to do it ? Please help.

 

Capture.JPG

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

AllisonKennedy_0-1599978553471.png

@Anonymous  You should be able to format the visual by selecting the slicer, then click the format painter icon and expand the "General" section. Turn Multiple Selection to 'off'. This won't give you radio buttons, but forces single select.

 

If you want radio buttons, you can use the built in slicer and turn single select to 'on': 

AllisonKennedy_1-1599978779743.png

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

3 REPLIES 3
AllisonKennedy
Super User
Super User

AllisonKennedy_0-1599978553471.png

@Anonymous  You should be able to format the visual by selecting the slicer, then click the format painter icon and expand the "General" section. Turn Multiple Selection to 'off'. This won't give you radio buttons, but forces single select.

 

If you want radio buttons, you can use the built in slicer and turn single select to 'on': 

AllisonKennedy_1-1599978779743.png

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Even with the multiple selection set to off it is possible to select multiple items when using the CTRL key. There is a bug in the Chiclet slicer.

Een_Steen_0-1608284649153.png

 

@Een_Steen  yes, you are right, users can use Ctrl key to multi select. This is not a bug, just limitation of chiclet slicers. Built in slicer has a single select option which we can set to on, as I explained in my post above this will give radio buttons and force single select. Turning multi select off just forces single select when ctrl is not used.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors