expand all nodes in decomposition tree

[space83]

below is my decomposition tree. any ideas how can i expand all the tree in production file untill CP3 without need to click every single nodes?

[Zubair_Muhammad]

Hi All

I created a decomposition tree custom visual which might address these problems.

• It allows users to expand all nodes simultaneously
• It allow users to select whether to display children only or all descendants on node click
• Users can add a target measure as well

Here is a short demo video of this visual

https://www.youtube.com/watch?v=xLwkKTc39UI 

[MustafaElkarim]

can i see you table relation cuz i have same strucher for data with break down and the breaksdown take the same value of the previous breakdown

[RKM]

Apologies for posted on old thread. Did you really get an answer here?

The one marked as solution, seems just one level but you in your question have asked how to expand all upto CP3 - means almost upto 5th level of drill. I doubt in Power Bi currently it is possible. 

@Pragati11 : Could you please review again, in case you found a solution to keep all elements shows for more than 1 level, could you kindly share the solution / pbix

[space83]

ya, actually i dont got my answer and i dont want stuck much time with this issue.

This report also not used in my organization.

[Pragati11 · Accepted solution]

Hi @space83 ,

I tried creating the decomposition chart, I expanded every single node and saved my pbix file. When I open again, my decomposition tree shows all the nodes expanded by default:

I have got the follwing settings under formatting for this visual:

Thanks,

Pragati

[RKM]

I guess you might have missed the point raised in the Original Question. @space83 talked about multiple levels.. i.e. more than 2.

What you designed is only level 2. Try to have another level after 'Category' and then try to expand all of the nodes, you'll see the problem.

[wgjunsay]

Hello, you said you expanded every node, but looking at your screenshot, it doesn't seem to be the case. Did you really expand on every node? Just came across this thread as I am experiencing the same issue right now. 

[jamoroso]

Hi @wgjunsay , Did you ever get an answer or figure out how to have all nodes expanded on your Decomposition Tree? I am also experiencing this issue and trying to find a solution.

Thanks,

Janet

[wgjunsay]

Hello @jamoroso unfortunately I haven't. It seems to be a limitation to the visual.