Forum Discussion
Creating a Line Chart Based by Supervisor
You probably need a 'lookup' table that has a unique list of Supervisor names and ID numbers. Use a relationship to join the ID numbers from both tables, then use the Supervisor name field in all your filters.
Thanks for the video; that was awesome. Helps to see. Unfortunately the cell values are not the same, but your response got me to look at the data further; I found I needed another table to make the connection.
PERSON TABLE TO A LABOR TABLE (Which has a PersonID and Labor Code)
The Labor Code cell values are those named "Implementer" in the PREVENTATIVE MAINTENANCE TABLE.
So connection solved!
Now a new issue...the SUPERVISOR name that displays is the person's number, i.e., 12345, and not their name. Any tips on getting the Slicer to display their name?
You probably need a 'lookup' table that has a unique list of Supervisor names and ID numbers. Use a relationship to join the ID numbers from both tables, then use the Supervisor name field in all your filters.