Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |