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 Al...
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.

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.