Visualisation for multi layered qualitative data

[sseth]

Hi all. I am facing extreme difficulty in producing a visualization for my need. My requirements are: 1. My filters are by college and by field of research code 2. the user needs to select the college and then the relevant field of research code 3. A list of parent indicators appears under that field of research code 4. When the user selects a parent indicator, it drills through further to a list of indicators 5. when the user selects that indicator, it displays examples under that indicator. So my data is very qualitative and layered and currently I am using a treemap visual and I have tried using card/multi level row card, but it is just not working. Can someone please provide some insights?

[v-henryk-mstf · Accepted solution]

Hi @sseth ,

First, you can create a martix visual, which visualizes the hierarchical structure between data. Then use the Treemap Bar Chart to create a view of the hierarchy. The slicer can represent the changes in the different hierarchies.

Also, you can refer to below blog:

Hierarchical Tree/Advanced Decomposition Tree for Power BI - Features (xviz.com)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sseth]

Hi @v-henryk-mstf I have used the zoomchart pie chart drill visualisation for now which serves my purpose. Thank you for the reply.

[v-henryk-mstf]

Hi @sseth ,

Thanks for your feedback.

Best regrads,

Henry

[Shaurya]

Hi @sseth,

My suggestion is that you use a donut or pie as your visual of choice and add the fields in the required heirarchy like College->Research->Indicator. That way every time you click on a sector it will drill down one level.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts