Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Modelling data to have drill down capability

Hi all. I'm trying to set up a data model so that multiple subcategories roll up into an overall category and I am able to represent the overall category first in the visualization, then drill down t...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi , Anonymous 

    There is no need to add additional hierarchy. 

    But you need to  unpivot your original  data columns to generate  two new columns .

    Then drag these fields to  column  of matrix to achieve the drill-through function as below:

     

    Check my sample file for more detais.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi , Anonymous 

There is no need to add additional hierarchy. 

But you need to  unpivot your original  data columns to generate  two new columns .

Then drag these fields to  column  of matrix to achieve the drill-through function as below:

 

Check my sample file for more detais.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.