Hierarchies in tables

[Anonymous]

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!

[v-xjiin-msft · Accepted solution]

@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.

[Ramvundavalli]

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

[Anonymous]

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 · Accepted solution]

@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]

Oh yes, This should work! 

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

Regards,
Ben

[v-xjiin-msft · Accepted solution]

@Anonymous

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

Thanks,
Xi Jin.