Forum Discussion
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 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!
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
8 Replies
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
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
