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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
@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':
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
@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':
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 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.
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