Allow a drill down across one visual to drill down on another

[Anonymous]

Hello! If we assume I have a treemap with a three level hierarchy with drill down enabled, and a bar chart with the exact same data just spread out along the time dimension, is it possible that when I drill down on the treemap, the bart chart also drills down BUT showing the split on the next level in the hierarchy. As far as I can tell it is impossible to add a hierarchy to the column series section of the bar chart and so the split is only possible ONE previously determined level.

Example:

If this is level 1 of my hierarchy and I have selected "Level 1" to be displayed in the column series then this is my starting point. This is good as I can already see the level one split on my treemap and the bar chart.

However, if I now drill down on the treemap to level 2 by clicking on the orange category, the treemap shows the level 2 split, whilst the bar chart has highlighted only the orange category data but doesn't show the level 2 split.

Would it be possible for the bar chart to show something like this? So showing the split on each level as we drill down on the treemap:

And then level 3 also showing the level 3 split, etc.

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

To my knowledge, it couldn't achieve in power bi for now.

you have to get it manually, and you could not drag multiple field into column series.

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft , that was my hunch, thank you for confirming. I'll wait a little longer and if no one else comes up with a solution I'll accept your answer.

[v-lili6-msft]

hi  @Anonymous 

Could you please tell me if have other problem about this case? If not, could you please mark the helpful replies as Answered? 😁

Regards,

Lin