Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

@Anonymous you can achieve this in 2 steps.

First unpivot the table suggested by @amitchandak 
Next, use the tooltip suggested by @v-yetao1-msft 
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.

Community_Mouse Hover_Tool Tip.png


View solution in original post

8 REPLIES 8
v-yetao1-msft
Community Support
Community Support

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 .

Ailsa-msft_0-1620375213088.png

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

Ailsa-msft_1-1620375213091.png

(3)Turn on Tooltip function in new page .

Ailsa-msft_2-1620375213092.png

(4)Select the visual you want to display Improvement Column Value, in the visual settings, select Report page for Type , select Tooltips for Page .

Ailsa-msft_3-1620375213093.png

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
Not applicable

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
Not applicable

Hello @v-yetao1-msft Kindly please extend your support and helpe me in solving this.

@Anonymous you can achieve this in 2 steps.

First unpivot the table suggested by @amitchandak 
Next, use the tooltip suggested by @v-yetao1-msft 
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.

Community_Mouse Hover_Tool Tip.png


Anonymous
Not applicable

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

@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
Super User
Super User

@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
Not applicable

Thanks for your response amit.

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.