Slicer for all data and partial data

[rachaelwalker]

I am looking for a solution that allows me to add a slicer/filter with custom text based on the data in a column. I have an employee type column with the following types:

Executive

Director

Employee

I want a slicer or filter that I can click "Include" to show all employee types and "Exclude" that I can click that shows only Employee (removes director and executives). 

I have tried creating a toggle action button using bookmarks but if I drill down in the visuals, then select my bookmark, what I have previously selected is reset.

I have tried a conditional column but the request is to have a filter that says Include or Exclude. My current slicer says Select All to get all of them to show. 

[sturlaws · Accepted solution]

Hi,

could you try to create a new table like this, call it e.g. Filters:

Filter

Include

Exclude

This table 

Next create a measure like this

Measures =
VAR _f =
    CALCULATE ( SELECTEDVALUE ( 'Filters'[Filter] ) )
RETURN
    IF (
        _f = "Include",
        1,
        IF (
            COUNTROWS (
                CALCULATETABLE ( 'Table', FILTER ( 'Table', 'Table'[EmployeeType] = "C" ) )
            ) >= 1,
            1,
            0
        )
    )

Add this measure to the filter pane of your visual, and set it to filter on equal to 1:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.