Slice multiple fields

[monkeysocks]

Hey,

I am looking for some help on slicing. I have 3 charts on a single page powered by the same table,

Total closed by user (closed_by)

Total assigned to a user (assigned_to) - This excludes closed

Total created by a user (created_by)

The data structure is the same for all 3 fields, what is the best way to go about creating only 1 slicer to slice all 3 charts without compromising the data in each of the charts?

Any help would be greatly appreciated, thanks in advance!

[amitchandak]

@monkeysocks , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[monkeysocks]

RecordID	Date_Created	Created_By	Date_Closed	Closed_By	Assigned_To
1	01/09/2020	User 1			User 1
2	01/09/2020	User 1	01/09/2020	User 1	User 1
3	01/09/2020	User 1	02/09/2020	User 2	User 2
4	02/09/2020	User 1	02/09/2020	User 2	User 2
5	02/09/2020	User 1	02/09/2020	User 3	User 3

E.g

01/09/2020 User 1 Created = 3
01/09/2020 User 1 Closed = 1
01/09/2020 User 1 Assigned = 2

[amitchandak]

@monkeysocks , Please find the attached file after signature

[VijayP]

@monkeysocks 

Question need to be rephrased. Once you create slicer in a page that will impact all the charts by default.

What is the required outcome. any snap shot is better to understand

[monkeysocks]

Apologies, the desired outcome is to be able to select a user and it filters all 3 charts individually on that user (Total by day)

Chart 1 will filter all records closed by that user

Chart 2 will filter all records that are assigned to that user (that are not closed)

Chart 3 will filter all records created by that user

The issue I have is that, the created_by, closed_by & assigned_to user fields could be different on any one record. e.g created by user 1 & closed by user 2. The charts should show all records that meet the individual criteria and should not be further filtered by the other fields values i.e Even though User 1 did not create the record, it should still count in their daily closed total if they closed it but not in their daily created total.

Does that make any more sense? 

[amitchandak · Accepted solution]

@monkeysocks , what I got from that. You need to have a user table and join to these three user columns(1 Active, 2 Inactive). And then use userelation choose which join will work

refer this : https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[monkeysocks]

This worked perfectly, all functioned as expected, thank you very much for your help!

[VijayP]

@monkeysocks 

One Slicer cannot handle multiple logics.