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
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
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?
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
This worked perfectly, all functioned as expected, thank you very much for your help!
One Slicer cannot handle multiple logics.
