Forum Discussion

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper IV
5 years ago
Solved

Slicer to Column relationship

Hello,   I have a slicer called 'job family' and i have a field called 'nominations'.  The 'job family' slicer values are: Finance, IT, HR.  My 'nomination' values are 5-IT, 7-HR, 10-Finance, 8-HR,...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Add a calculated column to your table like this.

    Nomination matches Job Family = CONTAINSSTRING('Table'[Nomination],'Table'[Job Family])

    It will return true when the nomination contains the job family:

    Then you use that as filter on your report page.

     

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

Add a calculated column to your table like this.

Nomination matches Job Family = CONTAINSSTRING('Table'[Nomination],'Table'[Job Family])

It will return true when the nomination contains the job family:

Then you use that as filter on your report page.

 

 

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper IV
5 years ago

Thanks! this makes sense, for 'containsstring', it will only let me choose a measure and not a column? does it have to be a measure?

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    5 years ago

    That's not true of CONTAINSSTRING.  In my example I am adding a calculated column to the table and only looking at the columns in the table.