Forum Discussion
On Mouse Hover Display another table column value
Hello All, I had created power Bi report based on SharePoint list using some DAX , But my client had extended requirment as he wants to show the value of another table column value to on mouseho...
Anonymous you can achieve this in 2 steps.
First unpivot the table suggested by amitchandak
Next, use the tooltip suggested by Anonymous
Create a new key column(%Key) with combination of Student ID and Subject.
I am not able to attach the pbix file. so attatching the screenshots.
Anonymous , You have unpivot the subjects and create common table subjects to join the tables, the only it will pass
https://radacad.com/pivot-and-unpivot-with-power-bi
Thanks for your response amit.
Why Should I unpivot when my dataset is already is crunched and in structured mode.