Forum Discussion

Ilia's avatar
Ilia
Frequent Visitor
10 years ago
Solved

Always one value selected in Slicer

Can we use in Slicer something like "Radio button" instead "Check box".  I mean that always one value have to be selected. 

13 Replies

  • Ilia,

     

    When you download the custom visual ChicletSlicer 

    Format > General > Multiple selection to OFF.

    Here it isn't possible to select more then one value.

     

    Regards,

    Jorre

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Good day

       

      Hi Jorre94,

       

      In using Chiclet Slicer, I have set Multiple selection to "off" and still if I use the Ctrl key I can select more than one item!

      • Anonymous's avatar
        Anonymous
        Not applicable

        This is a problem that with CTRL it doesnt work

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Ilia,

    Another option is after you create the slicer go to Format > Selection controls.  Set  Single Select to ON

    This doesn't completely do what you want it to do, since users can CTRL>Select to select more than one checkbox.  But they won't be able to select more than one checkbox without using the CTRL button.

     

    HTH,

    Michele

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion

    Ilia In power bi desktop you can set value for slicer and then publish report this will ensure your report in power bi service or anyone you share with will always have a value you selected for the slicer.

  • Ilia's avatar
    Ilia
    Frequent Visitor

    Thanks everyone for answers, but I meant something different.

     

    Step 1. There is only one value selected in Chiclet Slicer and everything looks good. Simple Card shows value for selected Chiclet.

     

    Step 2. But in Chiclet Slicer I can canceled my choise, thus none of the options were selected. And in this situation Simple Card summarizes all values. I don't want this. I need Simple Card shows only one value.

     

    So, how to avoid situation where User can deselect and none of the values ​​were selected?