Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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.

 

  • 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

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

      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's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support

        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