Slicer Select "Available"

[Tomasjhussey]

Hi,

I have this table

Year	Product Code
2015	1
2015	2
2015	3
2015	4
2016	3
2016	4
2017	2
2018	3
2018	4

I select "2018" from a Year slicer and the "All" from Product Code slicer (selecting 3 & 4)

when I deselect "2018" I would like to keep only 3 & 4 Product Codes, not all 1,2,3,4

is there a way to achieve this? I don't want to manually select 3 & 4, this is for a larger data set, thousands of products.

Thanks

[Nathaniel_C]

Hi @Tomasjhussey ,
Not sure if I understand your post, but is this what you want?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Tomasjhussey]

No, I DO NOT want to manually select 3 and 4.

I want to select 2018 from year, then select all available codes for 2018, then deselect 2018 and but keep the codes that were selected when I selected all available for 2018 

[v-shex-msft]

Hi @Tomasjhussey ,

You can write a measure to compare current row content and specific value and return tag, then you can apply it to visual level filter to filter records.

M filter =
IF ( SELECTEDVALUE ( 'Table'[Product Code] ) IN { 3, 4 }, "Y", "N" )

Notice: filter result will changes when you modify in measure formula.

Regards,

Xiaoxin Sheng

[Tomasjhussey]

Thanks for the response but that's not an ideal solution since it is static.