Forum Discussion
Hierarchies in tables
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.
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.
Solution SageAnonymous
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- v-xjiin-msft
Anonymous
Did you resolve your issue? Did my solution work for you?
Thanks,
Xi Jin.