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 email@example.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.
@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!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps