Help with Multiple Relationship Slicer

[bwelsh]

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?

[Phil_Seamark · Accepted solution]

Hi @bwelsh

Consider moving your user columns to rows.

eg,

Cat , User_01 , User_02 , User_03
A     1         2         3
B     4         5         6

to

Cat , UserNumber , User
A    01           1
A    02           2
A    03           3
B    01           4
B    02           5
B    03           6

In this format your slicer can connect to the User column and may behave in a more desirable way

[Phil_Seamark · Accepted solution]

Hi @bwelsh

Consider moving your user columns to rows.

eg,

Cat , User_01 , User_02 , User_03
A     1         2         3
B     4         5         6

to

Cat , UserNumber , User
A    01           1
A    02           2
A    03           3
B    01           4
B    02           5
B    03           6

In this format your slicer can connect to the User column and may behave in a more desirable way

[bwelsh]

How would I go about doing this in the query editor?

[Phil_Seamark · Accepted solution]

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.