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.

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.