How do i exclude categories based on slicer selection?

[Anonymous]

I have table with user names. i need a slice with options "all data" and "exclude user A". when 1st option is selected i need to display all data in the matrix. When i select second option i need to exclude user A from the matrix and display rest of the data. 

Structure of the matrix is user and task as rows with year on column with count(id) as values.

[Anonymous · Accepted solution]

Hi @Anonymous ,

After my researching, I updated my reply.

You can create a table with two options for the slicer.

Then create a measure for the visual-level filters.

Measure =
IF (
    SELECTEDVALUE ( 'Slicer Value'[Option] ) = "all data",
    1,
    IF (
        SELECTEDVALUE ( 'Slicer Value'[Option] ) = "exclude user A"
            && MAX ( 'Table'[user] ) <> "A",
        1
    )
)

Put the meausre into the filters and set up show items when the value is 1.

When "all data" is selected, all data are displayed.

When "exclude user A" is selected, data without user A are displayed.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.