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

Job Family is a slicer populated with the values from a column in your model correct?  When you say they come from the same data source what do you mean, do you only have one table of data?  Can you share a screen shot of your model layout and the list of fields in the tables?

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

I understand what you are saying now, but i have hoping there was a way to look up a string of data if your slicer is filter.  so, i would filter my slicer to a certain value and then it would lookup that value in the nomination column