Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Did you resolve your issue? Did my solution work for you?
Thanks,
Xi Jin.
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
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.
@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.
Oh yes, This should work!
I'll try it and let you know my findings.
Regards,
Ben
@Anonymous
Did you resolve your issue? Did my solution work for you?
Thanks,
Xi Jin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |