Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
I've encountered a scenario in which I think I need to unpivot measures and am not sure if that is possible.
In its current form, the data is displayed in a matrix like this, with each of the columns being a seperate measure:
Measure 1 | Measure 2 | Measure 3 | |
Location A | |||
Location B |
The users have requested a second matrix that would ideally look like this, with each measure as its own "row."
Location A | Location B | |
Measure 1 | ||
Measure 2 | ||
Measure 3 |
Is this possible? I don't think the values would be correct if I try to replicate those measures as columns.... any advice would be appreciated!
Solved! Go to Solution.
There is a setting under Format called "show on rows" or something like that. Try under the values section.
Wow...thank you... clearly was making this more difficult than it needed to be!! Appreciate the heads up because I never would have thougth to check that!
There is a setting under Format called "show on rows" or something like that. Try under the values section.
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |