Forum Discussion

Zancho's avatar
Zancho
Frequent Visitor
8 years ago
Solved

slicer

Hello!

Is there a way to limit how much is selected? What I mean there is a slicer with select all but I need to restrict to possibility choice only 1, 2 or 3 categories from the list.

  • OK that is somewhat different. I don't know of a way to prevent the user from selecting more than a certain number of categories. Of course if it would be sufficient to visually show the user that he is "misbehaving", there are solutions.

  • Anonymous's avatar
    Anonymous
    8 years ago

    Indeed, I agree with Erik. It's possible to alert your user they're doing something wrong with a measure that counts the distinct rows in your slicer column. Or something like that iis probably the most pragmatic solution

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi I'm not sure entirely what you mean, could you include some pictures of what you would like?

     

    If you are trying to filter your slicer so that only certain values are available, unfortunately that isn't possible. You cannot have a visual level filter on a slicer. It's a pain but if you think it should be included (it really should), then you can vote for that feature here:

     

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12545673-visual-level-filtering-in-slicers

     

    You could work around it by using a visual that isn't a slicer, like a bar graph, or perhaps you could create a small visual that isn't visible on your page but is filtering only the slicer so that it includes just the values you want.

     

    Thanks,

     

    Will

    • Zancho's avatar
      Zancho
      Frequent Visitor

       

      Thank you!

      What i want is if i select 3 items then i can't choose the 4th. I tried to draw what I whant to achieve, it's something like this:

       

      • erik_tarnvik's avatar
        erik_tarnvik
        Solution Specialist

        OK that is somewhat different. I don't know of a way to prevent the user from selecting more than a certain number of categories. Of course if it would be sufficient to visually show the user that he is "misbehaving", there are solutions.

    • erik_tarnvik's avatar
      erik_tarnvik
      Solution Specialist

      Page level filtering on the slicer does work though. Just drop your category into the page level filter box and select the categories you want to show.