Filter out rows in a table using a button or toggle

[TheV500Oshin]

Hello

I need a way of a button/toggle to filter out rows based on a string.

I have created a small table with the fields "Yes" or "No" and I need to filter a table depending on which button is pressed.

For example I have a field called JobTitle and if I press "Yes" I need to show all the rows that doesn't contain "CEO" and when I untick "Yes" I need to return all the fields back that does contain "CEO".

I don't want to use bookmarks but if there is another way of doing this that would be great.

Thanks

Oshin

[tamerj1]

Hi @TheV500Oshin 
Can share some screen shots of what your data looks like and what exactly you want to filter?

Thankl you

[TheV500Oshin]

Hello,

I cannot share screenshot as it sensitive data. I need to be able to filter out the string "CEO" from a column called Jobtitle but it has to be using a toggle for the user.

[tamerj1]

Two buttons are ok ( Yes, No ) or you need only one ( Yes )?

[TheV500Oshin]

Two buttons is fine thank you

[tamerj1 · Accepted solution]

@TheV500Oshin Here is the sample file with the solution https://www.dropbox.com/t/zcapitgXbnBiz4nX
The report looks like this 
This is the measure code

Measure = 
VAR Selection =
    IF ( 
        ISFILTERED ('Is CEO'[CEO?] ),
        CALCULATE (
            VALUES ( Employees[Jobtitle] ),
            Employees[Jobtitle] = "CEO"
        ),
        CALCULATE (
            VALUES ( Employees[Jobtitle] ),
            Employees[Jobtitle] <> "CEO"
        )
    )
VAR Result =
    IF (
        HASONEVALUE ( Employees[EMPID] ),
        Selection
    )
RETURN
    Result 

Please let me know if this answers your query or if you need any further modifications. 

[Samarth_18]

Hi @TheV500Oshin ,

You can create a bookmark with filter then add a button and put bookmark as action for your button.

Thanks,

Samarth

[TheV500Oshin]

Is there anyway of doing this without bookmarks? 

[Samarth_18]

@TheV500Oshin Create two pages one with filter and another with without filter and put button action as navigation to other page. Mark newly created page as hidden so user will not see in services.