Slicer: Select ALL logic

[savulesc]

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?

[v-kkf-msft]

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]

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

[v-kkf-msft · Accepted solution]

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]

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]

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]

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]

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.