Reply
Highlighted
Member
Posts: 55
Registered: ‎12-08-2017

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?

Moderator
Posts: 7,837
Registered: ‎03-10-2016

Re: best practice: use one table in multiple different filters?

@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