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.
Student Roll no | Name | Maths | Ecnomics | Physics
1008 David 78 7 76
1009 Steve 65 85 95
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
Solved! Go to Solution.
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 :
I have attached my pbix file, you can refer to it .
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.
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.
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
I will be glad if you share the Pbi file to my email id firstname.lastname@example.org .
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.
@sam_powerbi , You have unpivot the subjects and create common table subjects to join the tables, the only it will pass
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!