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 i...
  • 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. 

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

TheV500Oshin's avatar
TheV500Oshin
Regular Visitor
4 years ago

Is there anyway of doing this without bookmarks? 

  • 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.