Forum Discussion
Create Hierarchy for Pivot
I have a table with 132 response columns. under each column is # of times each response was selected. There is another column that has a measure of stress associated with each response. EX: ask bu...
Ritaf1983
Super User
Super UserHi Anonymous
If I understood you correctly you need one more unpivot :
Then you can create visuals with the wanted hierarchies :
The pbix is attached
If it is something else please show the desired result.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly