Forum Discussion
Solved
Slice multiple fields
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...
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-power-bi
monkeysocks , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
| 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
monkeysocks , Please find the attached file after signature