Forum Discussion
monkeysocks
5 years agoFrequent Visitor
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...
- 5 years ago
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
amitchandak
5 years agoSuper User
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
5 years agoFrequent Visitor
This worked perfectly, all functioned as expected, thank you very much for your help!