Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago
Solved

Filter Buttons

I have a report and one section of the report includes a table displaying comments and then a "Text Filter" visual to allow users to search the comments.     The report owner has now asked as well ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    StuartSmith  To use the filter, you need to create a measure that connects it to your data, so for example: 

     

    SuggestedFilter = IF( CONTAINSSTRING( Table[Comments], SELECTEDVALUE(Slicer[SlicerColumn])) , 1, 0)

     

    Then add this slicer to your table visual (and search box too if you want) and set to filter for only = 1 . 

     

    Note, this will only work for single selections in the chiclet. You may need more advanced DAX if it must work for multi-select.

  • StuartSmith's avatar
    StuartSmith
    5 years ago

    Think i figured it out...

     

    TEST_Key_Search_Word_Filter_Measure =
    VAR Key_Word = SELECTEDVALUE('Key Words'[Value])
    RETURN IF(CONTAINSSTRING(SELECTEDVALUE('Carrier Matrix'[OData__2_Contractcomments]),Key_Word),1,0)
     
    Does that look right?
AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

StuartSmith  To use the filter, you need to create a measure that connects it to your data, so for example: 

 

SuggestedFilter = IF( CONTAINSSTRING( Table[Comments], SELECTEDVALUE(Slicer[SlicerColumn])) , 1, 0)

 

Then add this slicer to your table visual (and search box too if you want) and set to filter for only = 1 . 

 

Note, this will only work for single selections in the chiclet. You may need more advanced DAX if it must work for multi-select.