cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
denpries Member
Member

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
Moderator v-yuezhe-msft
Moderator

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

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors