Excel: Power View Hierarchy

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


The previous chart showed revenue by Region. In the Axis dropdown, add two more fields: State and City. In the chart, double-click on the West region to have the chart change to show states in the west region. Double-click California to see all of the cities in California. To go back up a level, a new Drill Up icon appears at the top right of the chart.

  1. Create a hierarchy

  2. Double-click any column to drill down.

For more resources for Microsoft Excel