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 = 2monkeysocks , Please find the attached file after signature
