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 mousehover.
SharePointList 1
Student Roll no | Name | Maths | Ecnomics | Physics
1008 David 78 7 76
1009 Steve 65 85 95
SharePointList2
Student Roll no | Subject | Improvement
1008 Maths Needs to Impove in Algebra
1008 Ecnomics Needs to improve in all areas
109 Physics Excellent
Now my requirment is when every I mousehover to any of the subject of particular student in Powr BI Table(SharePointList1) my client wants to see the Improvement Column Value from SharePointList2 .
Can any one please help me how can I make this possible
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.
8 Replies
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
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
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.
