Interactive report with hierarchical data

[koushikB]

Community, 

I have a requirement for building 4 to 5 levels of the interactive hierarchical report. Currently, i am looking for any ideas or suggestions for getting report interactive. 

https://community.powerbi.com/t5/Best-Visual-Contest/Breakdown-Trees/cns-p/7368

Breakdown tree: 

My requirement fits good with above custom visual but I can't  find the code or custom visual anywhere.  Is there some place that I can find the visual. if anyone has a stand alone file for above custom visual please share it with me. 

I had tried with the below: 

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11g-visual-hierarchies-drilli...

This particular option is good for going to different levels of hierarchy but it is not allowing me to interactively filter with other reports at the same time. 

There is one other thing that I had a shot at is Visio integration with hierarchy data. But it doesn't seem to be working for hierarchical data.

https://powerbi.microsoft.com/en-us/blog/visio-custom-visual-is-now-in-public-preview-and-available-...

Thanks

Koushik

[koushikB]

Out of exploration, 

Drill down donut chart works well but I wish there can be some visual that can provide over all picture for hierarchical data

Thanks

K 

[v-yuezhe-msft · Accepted solution]

@koushikB,

Using the built-in drill down hierarchy feature in Power BI Desktop, you can interact with other charts.

Take the following sample as an example, when you turn off drill mode in the column chart and select a data section in the column chart, the table visual will be filtered.


Regards,
Lydia

[klabir]

Hi,

we released recently the Ultimate Decomposition Breakdown Tree Custom Visual. 

https://dataviz.boutique/2018/04/24/microsoft-power-bi-ultimate-decomposition-tree-visualization/

Get in touch with me if you need a trial version, will be in appsource soon as well.

BR

Klaus