Forum Discussion

savulesc's avatar
savulesc
Icon for Helper I rankHelper I
4 years ago
Solved

Slicer: Select ALL logic

I have a table with one column:

 

A

B

C

...

Z

 

I'm using this table to create a slicer. In this slicer I want to keep only specific values: B, C, E, F, L, M, N and also to have the Select All option.

The problem is that when I click on Select ALL option all the values are considered in the report, not only the ones that i want (B, C...N)

Is there a fix for this?

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi savulesc ,

     

    Another approach is to use this measure as a visual-level filter in all visuals that need to be filtered.

     

    Measure =
COUNTROWS (
    FILTER (
        VALUES ( Query1[Column1] ),
        Query1[Column1] IN { "B", "C", "E", "F", "L", "M", "N" }
    )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

7 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi savulesc 

     

    If the slicer is not selected, are you still wanting to show the records that you do not want to have in the slicer?  If you don't want the other records, just go into Power Query and filter out the values you do not want (i.e. A, D, G, H... etc) and then Close & Apply.  This will remove the others and only keep the relevant values you want.

     

    I may be missing something thought?  Let me know.

     

    Thanks,

    Theo

     

    • savulesc's avatar
      savulesc
      Icon for Helper I rankHelper I
      4 years ago

      Hi TheoC ,

       

      Unfortunately, i can't do that because i have another slicer based on the same table where i want to leave all the values.

      This was my idea to have another slicer based on the same table but with specific values.

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi savulesc 

     

    If you just want those specific values, you can select that slicer then add that column to the filter pane and set filter to shows just specific values.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!! 

    LinkedIn | Twitter | Blog | YouTube 

    • savulesc's avatar
      savulesc
      Icon for Helper I rankHelper I
      4 years ago

      Hi VahidDM ,

       

      I already did that, but like i said when i have the Select All option clicked all values will be considered, not just the ones that i want.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi savulesc ,

     

    First create a page-level filter to select specific values.


    Then add a slicer, which will not show all the data when you select "Select all".

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • savulesc's avatar
      savulesc
      Icon for Helper I rankHelper I
      4 years ago

      Page level filter is not an option for me because it will mess up all visuals' results.

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi savulesc ,

         

        Another approach is to use this measure as a visual-level filter in all visuals that need to be filtered.

         

        Measure =
COUNTROWS (
    FILTER (
        VALUES ( Query1[Column1] ),
        Query1[Column1] IN { "B", "C", "E", "F", "L", "M", "N" }
    )
)

         

        If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
        Best Regards,
        Winniz
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.