Slice filter for some values

[Anonymous]

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

[v-zhangti · Accepted 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.

[Anonymous]

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

[v-zhangti]

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/Power-Query/How-do-I-merge-multiple-Sharepoint-list-into-one-list/m-p/2029139 

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.

[v-zhangti]

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.