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.
Hi Anonymous
Please correct me if I wrongly understood your question.
I create a sample, and the result is as follows. If this is the result you want, you can try the function of Tooltips .
Follow the steps below:
(1)Create a one to many relationship between two tables .Filter from ‘SharePointList 1’ to ‘SharePointList 2’ .
(2)Create a new page named “Tooltips” and add a table visual with column ‘SharePointList 2’[Improvement] .
(3)Turn on Tooltip function in new page .
(4)Select the visual you want to display Improvement Column Value, in the visual settings, select Report page for Type , select Tooltips for Page .
Then when every you mousehover to any of the subject of particular student in Power BI Table(SharePointList1), your client will see the Improvement Column Value from SharePointList2 .
If you want to know more about Tooltip ,you can refer to the link :
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
I have attached my pbix file, you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
pradeeptResolver I
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 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
Hello Anonymous Kindly please extend your support and helpe me in solving this.