Forum Discussion
Slice multiple fields
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
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?
One Slicer cannot handle multiple logics.