Slicer to Column relationship

[mmills2018]

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, 10-IT, 3-Finance, 1-HR

When i filter by 'job family' slicer i want to somehow link my slicer to only pull the related value.  So, if I filter to HR, I want my data to pull in the values 7-HR, 8-HR, 1-HR. 

Any ideas on how i can acheive this?

[jdbuchanan71]

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]

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

[mmills2018]

yes, I only have one table of data. Job Family and Nominations are columns within the same data table.

[jdbuchanan71]

OK, then your slicer is already related to the field.  When you pick a job family in the slicer what that does is apply a filter to the table where only the selected job families are returned.  It will only show nominations where the job family is the ones you selected.

[mmills2018]

So, within my data, you can have a job family of IT but a nomination for HR.  So, I only want to pull those who have a job family of IT and a nomination of IT

[jdbuchanan71 · Accepted solution]

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]

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]

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.

[jdbuchanan71]

@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]

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.