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

mmills2018 

It's probably easiest to just add the 'Job family' column to your existing table like so.

Job Family = SWITCH(
    'Table'[nomination],
    "1-HR", "HR",
    "3-Finance","Finance",
    "5-IT","IT",
    "7-HR","HR",
    "8-HR","HR",
    "10-Finance","Finance",
    "10-IT","IT"
)
  • mmills2018's avatar
    mmills2018
    Icon for Helper IV rankHelper IV
    5 years ago

    not sure i am understanding what you are saying. Job Family is a slicer, nominations is a column, both are coming from the same data source. is the above suggestion a measure or column? My example is a small sample set there are hundreds of different vautes.