Forum Discussion
Helper IVSlicer 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, 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?
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.
10 Replies
- jdbuchanan71
Super User
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" )
mmills2018not 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.
- 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
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
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