Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Hierarchies in tables

Hi Everyone, 

I am trying to replicate a report that used to reside in Excel. The end result must look like this 


My issue is that i cannot find a way to get the same sort of hierarchy type treatment in the rows. For example having the day vs night shift under Employee type, and the date below that. 

I thought a matrix would handle this but its not working out :S


Can any one offer some advice?

Thanks!

Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Anonymous

     

    To achieve your requirement, you need to create a custom hierarchies. Then use Matrix visual to display data in Power BI.

     

    Please refer to following steps:

     

    1. Since you did not share us your source table structure and the sample data. I have assumed your source data is like:

     

     

    2. Create a Custom Hierarchie for your source table.

     

    3. Use Matrix visual to display the data.

     

    The result show like this:

     

     

    If above sample doesn't satisfy your requirement, please kindly share us your source table structure and some sample data. So that we can make some corresponding tests.

     

    Thanks,
    Xi Jin.

  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Anonymous

     

    Did you resolve your issue? Did my solution work for you?

     

    Thanks,
    Xi Jin.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Here is another variation of the report I need to replicate. You can see each cost type gets seperated into an activity and a day and night wuantity of hours.

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Icon for Solution Sage rankSolution Sage
      8 years ago

      Anonymous

       

      To achieve your requirement, you need to create a custom hierarchies. Then use Matrix visual to display data in Power BI.

       

      Please refer to following steps:

       

      1. Since you did not share us your source table structure and the sample data. I have assumed your source data is like:

       

       

      2. Create a Custom Hierarchie for your source table.

       

      3. Use Matrix visual to display the data.

       

      The result show like this:

       

       

      If above sample doesn't satisfy your requirement, please kindly share us your source table structure and some sample data. So that we can make some corresponding tests.

       

      Thanks,
      Xi Jin.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Oh yes, This should work! 

        I'll try it and let you know my findings.

        Regards,
        Ben

  • Ramvundavalli's avatar
    Ramvundavalli
    New Member
    2 years ago

    I was able to follow this and replicate it in Power BI Desktop,Can someone help me in doing this in Power BI Report builder how can we acheive this hierarchy in matrix visual for Power BI report builder ? I need to create a paginated report with data that has multiple levels of hierarchy ,please help