Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |