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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
denpries
Resolver I
Resolver I

best practice: use one table in multiple different filters?

Dear all.

 

I have a 'user' table. Standard MS Dynamics 365. 

 

I use this table to assign users to i.e. :

 

projectowners

projectdirectors

projecthelpers 

 

I have of course ID's that match from the projects to the user table.

 

However, when i set relations to the table, i want to create an individual slicer for each role. And perhaps for the sake of example, also a slicer for all three at once.

 

How should i approach this? The former question requires (i think) three unique tables filled with users in those roles only. The second one can be done with a relation to a common table.

 

How to best do this?

1 REPLY 1
v-yuezhe-msft
Employee
Employee

@denpries,

Do you have a role field in the Projects table and want to create slicer using this role field? Please share dummy data of Projects table and user table, also post expected result here.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.