Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi to all,
I am looking for a possible idea on my problem. I have a report which shows check-in and chck-out of employees (and externals) and the related table shows me results (name, surname, check-in and check-out date...). However, I want that when that when I select one of my group (in the selection menu' of the slicer), the related table will show me the results for those persons and not all. So I am wondering if there is a possible solution to that,
thanks a lot.
Let me know, in case you need more clarifications
Thank you guys
Solved! Go to Solution.
Hi, @Anonymous
I simulated some data I don't know if I can restore your problem.
Is this the result you want? If not, are you able to provide some data for testing? What do you expect the output to look like and can you show it with an Excel image?
Looking forward to your reply.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I simulated some data I don't know if I can restore your problem.
Is this the result you want? If not, are you able to provide some data for testing? What do you expect the output to look like and can you show it with an Excel image?
Looking forward to your reply.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks for your solution.
Yes, it looks like what I would achieve. But the problem is that the data is stored in Sharepoint lists and I would be able to visualize the co-workers by each group. So my question is, how to combine Sharepoint lists in power BI.
If you need more information please ask and I would be happy to provide you.
thanks again
Hi, @Anonymous
In response to your question about how to combine Sharepoint lists in power BI. This is the relevant document, hope to help you:
https://community.powerbi.com/t5/Desktop/Merge-5-SharePoint-lists/m-p/437926
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
You can refer to the following document to see if it helps you with your problem.
https://docs.microsoft.com/power-bi/connect-data/desktop-sharepoint-online-list
https://docs.microsoft.com/power-bi/create-reports/service-quick-create-sharepoint-list
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
43 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
45 | |
24 | |
21 | |
21 |