On Mouse Hover Display another table column value

[Anonymous]

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]

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.

[Anonymous]

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]

Hello @Anonymous Kindly please extend your support and helpe me in solving this.

[pradeept · Accepted solution]

@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]

Hello Pradeep,

I will be glad if you share the Pbi file to my email id infantd365crm@gmail.com .
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.

[amitchandak]

@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

[Anonymous]

Thanks for your response amit.

Why Should I unpivot when my dataset is already is crunched and in structured mode.