Forum Discussion
Helper IVSlicer to Column relationship
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.
Super UserJob 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?
Helper IVyes, 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
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.