From Decomposition Tree to Details in Power BI!!!

The Decomposition Tree is an amazing visual but how can we get to the details. Where's my drill through? Patrick walks you through how you can set this up in Power BI Desktop!

Create and view decomposition tree visuals in Power BI

Set up drillthrough in Power BI reports

Wyn Hopkins


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Decomposition #GuyInACube

[sheilahart]

I just published a report with a Decomposition Tree. Adding Drill Through now. Thanks Patrick!!!

[kyujinlee]

Decomp tree is my favorite visual, and my report viewers also like it very much. With this video, I will be able to create better reports and dashboards for my viewers. Thanks!

[guimatheus]

Nice solution! I have been using Decomposition Tree chart these days a lot, one thing they should fix is the tree header name when it's too long. There could an option to extend and maybe create scroll bar at the bottom or something else.

[AccessAnalytic]

Thanks for the shout out Patrick (Wyn here 😁)

[hius]

Nice! Decomp trees are some of my favorite visuals and I never realized you couldn't drill from them.

[terpstry]

I was not aware of this option but very useful. So thanks for doing the video on it.

[baklavatummy]

Great video, thank you. I'd love to have the ability to expand all the nodes in the tree, rather than having to click into each path.

[dessaleeyasu]

Hey Patrick, thanks for all you do in power BI area. Just quick question could you please do a video on pausing automated report a database refresh fails? Thanks 🙏

[unbiasgaming]

Can you select to drill down using more than one parameter? It looks like you can only drill through on one.

[ahmedsamir]

there is possibility to add percentage beside the number ? for example : 2, 000 (49%), as i see you can make the value numbers or percentage but not both.

[jameslaine]

How did you configure the 'Drill Through" to go to that specific 'details' page in your report file? I have a report file with many pages; how to chose which one opens when 'drill through' is pressed?

[narendrababu]

How can i drill through decomposition tree without right click. I just need to drill through with single click. Is that possible?

[antoniocarlosgariano]

Hey Patric, how do I add a dynamic title to my drill through page based on the decomposition path selected?

[mremkov]

I have 4 decomposition trees on slide 2. Their "analyze by" field is different. Each is a different bookmark. On slide 3 i have the same 4 decomposition trees, but made as a drill trough page. Now when I click on something on slide 2 and click "drill trough" i gets me to the DT slide, but on whatever bookmark was opened before.

Example - I am on bookmark 1, click on DT, it brings me to the next slide but on bookmark 3. I can click on bookmark 1 and the result is there for me to explore it, but can i make it so that DT on bookmark 1 brings me to bookmark 1 on the DT page ?

[riyagarg]

Can someone help with dynamic conditional formatting of filled maps in PowerBi . Thank you so much

[PET]

Hi Patrick and Adam, I have been facing an issue with date cycle please help me out
Issue:- One of the table in the data follows different date cycle(26th of last month to 25th of current month) from other data(1st to 30 or 31 of current month), as we select the month in the slicer from date table, the visual(I am using cards and line trend for this date cycle) which follows date cycle (26th of last month to 25th of current month) should show the values according to that date cycle whereas the other visuals should show normally (from 1st to 30th or 31st) of current month

[FredericLEGUEN-Excel]

Wyn, @AccessanalyticAus, congrats on your trick 👍👍

[kevinmann]

I just added a twist and it KIND OF worked. So, I added a measure field parameter to the decomp tree (mind-blowing). And it worked! You cannot use field parameter columns for the "explain by" columns; that is still individual drag/drop (sad). For the drill through, you cannot just use the measure field parameter. For example, if you have productSum$ and productSum% in your measure parameter list, you have to add them individually to the drill-through fields, which technically can create some extra control for you if you wanted to limit the measures that will drill through to your detail page.

[Vaultdorr]

"If you're finding us for the first time, hit that subscribe button". I guarantee you that a person finding you for the very first time will not do that 20 seconds into the video they haven't watched from a channel they haven't watched. So it's a pointless waste of time.