Slicer with multiple criteria values

[Anonymous]

Hi!

If I have a table like this:

How is it possible to create slicer (or preferably ChicletSlicer) in which I could choose from two alternatives. Alternative one would show values from both categories and alternative two would show values from only category 1,

Like this (these are two states of the report):

Great thanks for your help in advance!

-tnmaki

[v-chuncz-msft · Accepted solution]

@Anonymous,

Add a separate table for Slicer and use measure below.

Measure =
IF (
    SELECTEDVALUE ( Table2[Column1] ) = "Category 1",
    CALCULATE ( SUM ( Table1[value] ), Table1[category] = 1 ),
    SUM ( Table1[value] )
)

[Anonymous]

Thanks, Sam!

I guess that would do it!

I ended up doing a separate table like this and using name field in the slicer: