Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sasidhar_g
Regular Visitor

Multiple hierarchies in Power BI in Desktop

Hello All, 

 

Could it be possible to have more than one hierarchy enabled in Power BI report that is accessed from SAP BPC system. 

 

For example i have the below report in BPC that has hierachy on Cost center and Accounts  and in Power BI i am not seeing an option to enable them both simultaneously.Am i m missing some thing.Thank you so much for guding me here,

Sasidhar_g_0-1686196161478.png

Best Regards,

Sasidhar 

 

1 REPLY 1
lbendlin
Super User
Super User

You can compose whatever hierarchies you like (even they don't make sense) by placing the fields into the Row or column area of a matrix visual (for example). Many other visuals support ad-hoc field hierarchies.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.