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")

     

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

Dear Fhill, Thank you for your timely response and the code that you had provided. The code was very helpful in terms of which nothing had been selected as well as someone selecting multiple options. To expand upon your code that you gave me i have used the following in order to use this crosstables.

IF(AND(DISTINCTCOUNT(table1[Region])= 1, DISTINCTCOUNT(table2[Geography])= 1), SUM(Values[#Values]),"ONE selection please")

Thank you again for helping me out,

Regards, 

Microsoft Rookie.

roshramkar's avatar
roshramkar
Regular Visitor
8 years ago

Hi,

Where did you write query for that control???

  • microsoftrookie's avatar
    microsoftrookie
    Icon for Advocate II rankAdvocate II
    8 years ago

    I wrote it as a measure

    Regards,

    Microsoft Rookie