Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Slice filter for some values

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

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

I simulated some data I don't know if I can restore your problem.

vzhangti_1-1639722240240.pngvzhangti_0-1639722211639.png

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.

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

I simulated some data I don't know if I can restore your problem.

vzhangti_1-1639722240240.pngvzhangti_0-1639722211639.png

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
Not applicable

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/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.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.