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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Analysis services cube- Show all fields when Hierarchy is created on Dimension

Hi All,

Checking if we can see all fields by default without showing more fields when a hierarchy is created on a dimension. I know we can create all fields as a hierarchy to show all fields at the top level. Is there any way other than that? 


Please let me know. 





New Member

@v-huijiey-msft - Hi Yang, 

Thanks for the response. I was looking at the cube analyis in just excel. Its is not on Power BI side, its on Excel(Cube connection)

Community Support
Community Support

Hi @SusheelRB ,


Power BI Desktop does not provide the ability to completely disable or remove the hierarchical structure inherent to the Analysis Services cube data model.


There are some alternatives:


Using the matrix visual, you can turn off step layout, which visually indents the levels of the hierarchy. This aligns all hierarchy levels to the left, giving a flatter appearance.


Go to the Format pane of the matrix visual, expand the Row Headers card, and set the Ladder Layout toggle to Off.


Turning off subtotals for rows and columns can also help reduce the hierarchical appearance by removing summary rows/columns that are often associated with hierarchical grouping.


In the Format pane, set the Row Subtotal and Column Subtotal sliders to Off.



Select the table, right-click and select "Expand all". This option allows you to see all fields.



While these steps do not remove hierarchy from the data model itself, they can help present the data in a way that minimizes the emphasis on hierarchical relationships in the visuals.


If you have any further questions please feel free to contact me.


Best Regards,
Community Support Team


If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.