Forum Discussion

TheV500Oshin's avatar
TheV500Oshin
Regular Visitor
4 years ago
Solved

Filter out rows in a table using a button or toggle

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's avatar
    tamerj1
    4 years ago

    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. 

8 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi TheV500Oshin ,

     

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

     

    Thanks,

    Samarth

      • Samarth_18's avatar
        Samarth_18
        Community Champion
        4 years ago

        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.

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

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

    Thankl you

    • TheV500Oshin's avatar
      TheV500Oshin
      Regular Visitor
      4 years ago

      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's avatar
        tamerj1
        Community Champion
        4 years ago

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