Forum Discussion
Solved
CONCATENATE VALUES for Tooltip in a Matrix
Hi All, I have below dataset City Company Employee ID Department Name Calgary Company-A 121 21230 BOB Calgary Company-A 122 21240 Allen Calgary Company-A 121 21250 BOB ...
MURTAZA I have tried to solve your problem. This is what I did
1. Created a summarize table
Summarize = SUMMARIZE(Sheet1,Sheet1[Name],Sheet1[Department])2. Linked two tabels on Name fields3. Created a new tooltip that you can use. I have used matrix table instead of Card
4. Below is the output
I have attached pbix file here as well. let me know if it helps you. Happy to help
MURTAZA I have tried to solve your problem. This is what I did
1. Created a summarize table
Summarize = SUMMARIZE(Sheet1,Sheet1[Name],Sheet1[Department])
2. Linked two tabels on Name fields
3. Created a new tooltip that you can use. I have used matrix table instead of Card
4. Below is the output
I have attached pbix file here as well. let me know if it helps you. Happy to help
