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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
akash0800
Helper I
Helper I

Enable single selection in filter

Hi,

I am stuck at an incident.

I am trying to apply filter on all pages, but want to make a single selection. However it did not met my business need as the end user could still make multiple selections by holding ctrl key. Kindly suggest a way out of this situation.

 

Eg: the user should be allowed to choose only one option between the 3 available options at a time.

Group A, Group B or Group C.

 

Thanks,

Akash0800

1 ACCEPTED SOLUTION

Hi,

Finally since nothing worked. We ended up adding a slicer.

Thanks,

Akash

View solution in original post

7 REPLIES 7
darkinvader
Frequent Visitor

Hi Akash,

You can change the Slicer settings in Visualization pane, you can diselect all the options and opt for Single Select

darkinvader_0-1677141515966.png

 
 

darkinvader_3-1677141585092.png

And this should be able to solve your problem.

Regards
Darkinvader

If you find your solution do check it as a solution

Any updates to this? I'm still seeing the same thing.

 

@darkinvader read the question.  He said filter, not slicer.

I'm seeing the same thing.  Single selection slicer setting is not being transfered during publishing to the service

amitchandak
Super User
Super User

@akash0800 , enable the single select option for the slicer in the property

 

if you need single select with all

Single Select with Select All : https://youtu.be/plGqCEZRfXU

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hi Amit,

I applied single select, but the problem here is that the end user is still able to make multiple selections.

I actually wanted to have only one selection at any given time. But this is getting override by holding ctrl key.

Thanks,

Akash

Infact we want to achieve this functionality without using a slicer.

Hi,

Finally since nothing worked. We ended up adding a slicer.

Thanks,

Akash

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.