cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sam_powerbi
Helper I
Helper I

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

@sam_powerbi you can achieve this in 2 steps.

First unpivot the table suggested by @amitchandak 
Next, use the tooltip suggested by @Ailsa-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
Ailsa-msft
Community Support
Community Support

Hi @sam_powerbi 

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.

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

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

@sam_powerbi you can achieve this in 2 steps.

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

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

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

@sam_powerbi , 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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks for your response amit.

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

 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors