Forum Discussion
Help with Multiple Relationship Slicer
I have table that contains three columns (let's call these USER_01, USER_02, USER_03). I have these connected to a USER table that contains two columns (USER, ROLE) using 1 active and 2 inactive realtionships. The problem is that I need to be able to slice the first table by role. This works fine if I slice by the role of the active relationship, but I get nothing when sliced by a role tied to an inactive relationship. Does anyone know how I can achieve this?
Hi bwelsh
Consider moving your user columns to rows.
eg,
Cat , User_01 , User_02 , User_03 A 1 2 3
B 4 5 6to
Cat , UserNumber , User
A 01 1
A 02 2
A 03 3
B 01 4
B 02 5
B 03 6In this format your slicer can connect to the User column and may behave in a more desirable way
I think the unpivot command can help that, or Transpose. Play with both and you should be able to create a table in the format I suggested.
3 Replies
Hi bwelsh
Consider moving your user columns to rows.
eg,
Cat , User_01 , User_02 , User_03 A 1 2 3
B 4 5 6to
Cat , UserNumber , User
A 01 1
A 02 2
A 03 3
B 01 4
B 02 5
B 03 6In this format your slicer can connect to the User column and may behave in a more desirable way
How would I go about doing this in the query editor?
I think the unpivot command can help that, or Transpose. Play with both and you should be able to create a table in the format I suggested.
