Forum Discussion
Solved
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 real...
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.
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
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.