Andy Wilbourn on 09 Feb 2017 19:00:31
We have found that if you set a filter to be single select the user is able to use the CTRL key and select multiples. This seems like it should not be allowed. We have a DAX calc that needs to use the filter and can only handle one value selected, so since the system allows multi-select when we configured single it breaks our report.
Administrator on 21 Jan 2022 02:58:44
Merged several related ideas into this one. Thank you, and please continue to vote on this feature!
- Comments (14)
- Merged Idea (4)
RE: Disable CTRL clicking a filter if the filter is set to single mode
The filter pane feature "Require single selection" does not do what its name says. This should be either improved (preferably with radio button) or renamed to reflect its true functionality.
Similar related ideas, that could be merged into this one:
https://ideas.powerbi.com/ideas/idea/?ideaid=b95e65b5-e8a9-eb11-89ee-0003ff452f24
https://ideas.powerbi.com/ideas/idea/?ideaid=4d620a85-29c6-4aec-8a17-8cdccf3abd9d
https://ideas.powerbi.com/ideas/idea/?ideaid=ddec0f98-5830-4783-a82d-30f65751ef68
https://ideas.powerbi.com/ideas/idea/?ideaid=76258bb2-43ea-eb11-ba5e-501ac50a6edb
https://ideas.powerbi.com/ideas/idea/?ideaid=de3d308d-0534-460d-84b5-8ff4103e36e1
https://ideas.powerbi.com/ideas/idea/?ideaid=908249fe-d95b-eb11-8fed-281878de77da
https://ideas.powerbi.com/ideas/idea/?ideaid=e5e1f65d-cceb-423d-9c9e-f9ecd668c2a3
https://ideas.powerbi.com/ideas/idea/?ideaid=05221ad5-a2b6-475a-821e-a77aaa2e88ad
RE: Disable CTRL clicking a filter if the filter is set to single mode
This idea is so critical - please take a look at this one, Microsoft!
RE: Disable CTRL clicking a filter if the filter is set to single mode
If I have two fields in Filter pane, when I select one value, 'Select All' option is appearing in other one even though, 'Require Single Selection' is checked. When I Uncheck and Check, just 'Select All' go away but comes back when use other filter. This doesn't make sense.
RE: Disable CTRL clicking a filter if the filter is set to single mode
Your DAX calculation should check to make sure that only 1 value is selected and then proceed with its calculation. You can use COUNTROWS('Table')=1 or HASONEVALUE('Table'[Column]).
I like having Ctrl as an option for multi-select. It saves the confusion of remembering whether multi-select is on or not or of remembering to toggle it.
I think that a stronger option than what you are suggesting would be to be able to remove the ability to multi-select from a slicer.