Forum Discussion
Hierarchy Multi row visual
Hello,
How can I create this visual?
Requirement: Category shown horizontally with metrics (sales, margin etc) below it. Then each category has sub category shown below it vertically with the same metrics.
Something like multi row card but with hierarchy
Thanks in advance.
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.
4 Replies
Dr_BB Have a look at the Power KPI Matrix visual by Microsoft or the KPI by Powerviz out in AppSource.
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.
Hi Dr_BB
Thank you for reaching out to the Microsoft Fabric community forum.
I would also like to thank you GeraldGEmerick and d_m_LNK for your active participation and for sharing solutions within the community forum.
I hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please feel free to contact us. We are always here to help.
Best regards,
Community Support TeamHi Dr_BB
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
