Forum Discussion
On Mouse Hover Display another table column value
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.
Hello Ailsa,
Thanks for your support , Yes this is the requirment you had posted.
But I need to show the tooltip infomration for a particualr subject when I mousehover on it.
Example :
If I mousehover on Phycics subject for Student Rollno 1008 it should show only Physics tooltip of 1008 Student,
And If i mouse hover on Maths Subject for Student Rollno 1009 it should show only maths tooltip of 1009 Student
Resolver IAnonymous 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.
Hello Pradeep,
I will be glad if you share the Pbi file to my email id [email protected] .
Tried using Ailsa Process and able to get the tooltip infomration on mouse hover but if I map 1:* relationship .
And I don't get any result on 1:1 relation mentioned by you in screenshot 1- pradeept
Anonymous you have to do unpivot also. then only will get 1-to-1 relation ship. the key would be Student-Subject.
I could not send any mail outside organization. You can refer to my earlier post. I provided the screen shots.