The fastest way to
perform pivot analysis 
in Power BI

Expand/collapse enabled hierarchies

Expand collapse hierarchies in rows & columns manually or to a specific level​

Layout options​

Leverage excel-like layouts such as classic, stepped, outline and more​

Values on rows or columns​

Show measures on rows or columns using the pivot mode​

Reorder rows and columns​

Click-and-drag to reorder rows and columns with ease​

Configure totals & subtotals​

Change the way in which totals, and subtotals are positioned in the visual​

Custom aggregations​

Define aggregations for totals and subtotals at the visual-level without using DAX​

Group rows & columns​

Create row and column hierarchies at the visual level​

Advanced filtering​

Filter values in each column as you can do in spreadsheets using the KPI Explorer​

​Insert quick formula columns​

One-click options to insert columns such as % contribution to grand total, running total, ranking within group​