05-25-2018 01:16 PM
I have a 'user' table. Standard MS Dynamics 365.
I use this table to assign users to i.e. :
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?
05-27-2018 07:50 PM
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.