Breakdown Trees

by fredrikheden Regular Visitor ‎09-23-2015 09:35 PM - edited ‎09-23-2015 09:39 PM

The Breakdown tree makes it possible to visually display the full drill-down path of a measure. By keeping all levels in the drill-down path visible you will get a good overview of how your numbers break down, from the top level to the details at the bottom.





People choice tweet:

by fredrikheden Regular Visitor
on ‎09-27-2015 01:35 AM

@spatney: My code is now updated to use the SelectionManager instead. Thanks for pointing that out.

My fork is also updated to the latest Microsoft version so any problems with trying out the visual yourselves should be gone.

@JDE: Try to copy/paste the code again and I hope it works fine now.


by Tas Regular Visitor
on ‎09-29-2015 05:53 AM

Awesome work sir.  I love this representation.

by jdt008 Regular Visitor
on ‎10-01-2015 08:11 AM

This is a tremendously valuable visual.  Excellent work.  As a lay person to the visual development world, how can we make use of this visual in our dashboards?  Thank you!

by elliotdixon Member
on ‎10-26-2015 02:42 PM

I don't see this in the Visuals Gallery?

Will it get added there?

by kishore_1st Frequent Visitor
on ‎11-02-2015 04:27 AM

We are looking for this chart as PBIVIZ file. Is this possible to share and put an attachment in the same place

by JorgenHNO3 Frequent Visitor
on ‎11-02-2015 01:03 PM

Will this be available in the visual gallery it looks so cool Smiley Happy

by tomneo007 Frequent Visitor
on ‎11-03-2015 12:17 PM

Vers good job Sir !! Smiley Happy Hopefully it will be available on the visual gallery... Thanks !

by vaseknemec Frequent Visitor
on ‎12-16-2015 07:02 AM

Please add this fantastic vizual to gallery (I know it more than 15y from ProClarity and use it too much). Thank you

by tenaciousdata Frequent Visitor
on ‎01-30-2016 10:10 AM


@fredrikheden, (or anyone) @spatney ?


Can you do  a step-by-step on how you plug this thing into Power BI desktop.


I know there is this:


Git +Node.js dependencies 


Even have the core visualizations working in visual studio.....not bad for a gridhead if I don't say so myself but I don't see how to acctually use Breakdown tree in Power BI desktop.


@leonardmurphy any thoughts on this? Have a use case where I need to put this to work.

by fredrikheden Regular Visitor
on ‎01-31-2016 10:23 AM


I'm glad you like the Breakdown Tree visual. I've had a lot of requests to submit this one to the Power BI Visual Gallery. However, it utilizes some not-supported methods for integrating to the drill-down/up functionality of Power BI, which makes it hard to make this one a production ready official visual. For you who want to use it anyway (be ware of the known issues) I have added a pbiviz file to my git repository. Use the link below to download it.


Breakdown Tree, PBIVIZ file:


Breakdown Tree, known issues:


Have fun!