Struggling with adding 2 hierarchies in pivot view in Excel and Power BI

[Anonymous]

I need assistance with creating the below SAP BW report view of having 2 hierarchies in a single report in Power BI or Excel. I've tried different options for this but not winning. I have Profit center and Account hierarchy that needs to be displayed as shown on the screenshot below from SAP. This is possible in SAP but not working the same in Power BI and Excel. Any of the options will be helpful. I'm using Power BI semantic layer dataset to build the excel pivot view. All my measures and columns are coming from the Power BI dataset.]

SAP Report View 2 hierarchies

In Excel: I was able to add both hierarchies in Excel as shown on the below screenshot but when its expanding its expanding to the right instead of expanding downwards for each of the hierarchies. This does not work correctly.

In Power BI: I was able to add both hierarchies but they both on the same column which will not work as the required solution should display both hierarchies next to each other like the SAP report view from above.

Limitation with the current solution

When you drilldown its expanding to the right instead of drilldown downwards for each of the hierarchies. This does not work correctly. It should drilldown within the same column like the first view on the SAP view.

Your assistance will be highly appreciated.

Thanks

[lbendlin]

When you drilldown its expanding to the right instead of drilldown downwards for each of the hierarchies. This does not work correctly. It should drilldown within the same column like the first view on the SAP view.

Maybe keep using SAPBW then?

What you require goes against the Power BI design principles.

[Anonymous]

The issue is SAP BW reporting is getting decommissioned by the end of this year. Hence i need to fix this asap.

[lbendlin]

create separate matrix visuals, each with their own row field hierarchy.