Reply
Frequent Visitor
Posts: 11
Registered: ‎07-19-2017
Accepted Solution

Interactive report with hierarchical data

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...

 

Drill down.PNG

 

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

 

 

 

 

 

 

 


Accepted Solutions
Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Interactive report with hierarchical data

@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.
1.JPG2.JPG3.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Frequent Visitor
Posts: 11
Registered: ‎07-19-2017

Re: Interactive report with hierarchical data

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

Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Interactive report with hierarchical data

@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.
1.JPG2.JPG3.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advisor
Posts: 45
Registered: ‎03-20-2017

Re: Interactive report with hierarchical data

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