Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |