Forum Discussion
Hierarchy Multi row visual
- 8 months ago
You could definitely do each row as a matrix with using the switch colums to rows feature under the values section in the build menu in the matrix visual. Then you would need to format the headers as needed. However getting them to be related would come down to filtering.
You could probably do the same thing with each column as a matrix in your visual above by creating the category and subcategory all as stacked rows and then your metrics all as measures. Then you would just need to jam them all together basically to get it to look how you want. Not ideal native solution but an option.
You could definitely do each row as a matrix with using the switch colums to rows feature under the values section in the build menu in the matrix visual. Then you would need to format the headers as needed. However getting them to be related would come down to filtering.
You could probably do the same thing with each column as a matrix in your visual above by creating the category and subcategory all as stacked rows and then your metrics all as measures. Then you would just need to jam them all together basically to get it to look how you want. Not ideal native solution but an option.