Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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 @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.
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.
@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
Thanks for your response amit.
Why Should I unpivot when my dataset is already is crunched and in structured mode.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |