Forum Discussion

microsoftrookie's avatar
microsoftrookie
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Disabling the Cntrl+ select option to only allow single selection

Hello, the issue that I am asking for help on is that on my Dashboard that I intend on eventually publishing does not prevent people from using the keyboard control of selecting multiple options on s...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi microsoftrookie,

     

    Current power bi cannot disable multiple select through press the ctrl key + click. For this scenario, I'd like to suggest you submit an idea about this requirement.

     

    Regards,

    Xiaoxin Sheng

  • fhill's avatar
    fhill
    9 years ago

    Crazy idea... what if you don't return a result if they select more than one value?  VERY 'un-user friendly', but might work...??

     

    OneValue = IF( DISTINCTCOUNT(Table1[Region]) = 1 ,SUM(Table1[Value]),"One Value Only")

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Actually try using the Hierarchy slicer in the marketplace.  Do the same "single selection" option but for this one it actually accomplishes what you want...to not allow someone to select more than one thing even if they hold the CTRL key.

 

You don't have to use it in a hierarchy, but you can do that as well.