Forum Discussion
Solved
Need help on returning the text value into table based on dynamic slicer
Hello Everyone, I am working on an HR project and encountered this problem. Problem: I wanted to return the Candidate name from the table based on slicer value and shows the respective candidate na...
Hi shikha3107 ,
Don't know if you have any relationships between you tables but you must make the following relationships:
- Candidate[CandidateKey] 1 -> * Fact_Combined[CandidateKey]
- Role[RoleKey] 1 -> * FactCombined[RoleKey]
Be aware that if you have the filter from the tables setup in a single option your table will not filter each other you need to place also the Role Name in the visualization in order to have the desired name.
If you just want to present the names without the role name you need to set the filters to both.
See attach file.
Just like Felix said, and you don't need to use lookup. I created this in the pbi, it works fine. Please see the screenshots below.