Forum Discussion
Using SelectedValues to show in Name Card
Hi Everyone!
I hope somebody can help me with this problem.
I am have 2 slicers from 2 different tables
QA[Agent Name] - returns the agent name
QA Summary[Cycle] = returns what cycle the agent was evaluated from
What I want to achieve is to show in the Name Card Visual the agent's overall mastery level in a particular cycle.
example:
Agent Name Cycle Overall Mastery Level
Jane Doe 2 Effective
James Smith 2 Advanced
of course dragging the column 'overall mastery' in the name card visul wont work because it doesnt change the value whenever I select a different agent or cycle.
Please help!
Hi hhasmin ,
If I understand correctly Cycle and Mastery are on one table joined to an Emp table.
So, I did a quick input tables and visuals. Is this what you are looking for in the visuals?
Just dragged the columns for the slicers, and the columns for the table.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielThis is nothing selected.
This is Felicia Cycle 2 selected
Emp table
Mastery table
1 to many relationship
7 Replies
Hi Nathiel,
the table is QA Summary[Cycle]
Hi hhasmin ,
So it is on the same table as one of your slicers. Is there a relationship between the two tables? If not could there be? If there is no possible way to link them, you may have to create an interrmediate table or add a column to one of the tables. For example, is there a unique identier number, like employe id in the employee table? You could then add a column in the Summary table with that column such as EID, then relate the two tables.
@If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
