Forum Discussion
Filter Buttons
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.
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?
Thanks, I had got as far as getting the "SELECTEDVALUE" displaying in a card and was then going to figure out where to go from there.
I have tried your suggestion, but the "CONTAINSSTRING" parameter only displays existing measures and if I enter the table/column manually, I get the red squiggly error line. Any ideas why?
Think i figured it out...