Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Multi select slicer

Hi Everyone,

 

I have a slicer in which i have "select all" option and i want to show two other option appliying visual level filtered from the slicer values.

 

Example :

Scenario is :-

When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded.

But he can select the other two option avaliable individually as an example if he select compliance than he will see filterd value of compliance only.

 

can ayone help me to achieve this Ahmedx , amitchandak , Ritaf1983 , Fowmy , lbendlin  .

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi All, 
    I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded

    No, "Select All"  literally means "select all". Meaning "include all".

    Keep in mind that "Select none"  is the same as "Select All"  in Power BI world. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Can you give me other way around to give user an option to do the following.
      1. Select All ( he should be able to select all option excluding the other two option)
      2. Select one option which in our case is suppose "Compliance"
      3. Select one option which in our case is suppose "Premier"

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi All, 
    I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.