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.

     

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous the best practice would be to unpivot your data in Power Query and then create hierarchy in the Power BI.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡