Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA

If your data model has a hierarchy, you can use it in Power View. You can also create a new hierarchy from scratch in Power View.

The advantage of having the hierarchy in a data model is that you can use it in every Power View sheet or report you build on that data model. You can only create a hierarchy in the Data Model in Excel by going to the Power Pivot window. Read about creating hierarchies in Power Pivot.

Video: Hierarchies in Power View

This data model already has a hierarchy called SDE, consisting of the fields Sport > Discipline > Event. With one click you can add the hierarchy to a Power View report.

Add an existing hierarchy to your Power View visualization.

If your data model doesn’t have a hierarchy, you can create one in Power View, too. Just adding multiple fields to the Rows or Columns box for a matrix creates a hierarchy for that matrix. Adding multiple fields to the Axis box of a chart creates a hierarchy for that chart. With this hierarchy, you can now drill up and drill down in the chart or matrix.

You can put fields in any order in a hierarchy. It needn’t be a natural hierarchy like Category > Subcategory > Product. It could be Category > Year > Continent.

Create a new hierarchy in Power View

SQL Server Analysis Services tabular models can also have hierarchies that you can use in Power View sheets or reports.

Top of Page

See Also

Add drill-down to a Power View chart or matrix

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Shoes Vintage Boots Western Rockabilly Brown Mens 11 Tan Cowboy Acme D Country SPPw7a

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

Top of Page

Expand your Office skills
Explore training
Get new features first
Join Office Insiders
USA 90's Sandals UK5 Brown Vintage Made Elastic 5 the Stretch in Women's Block Fisherman 5 5 Shoes Eur38 Strappy 7 Size US7 Heel Shoes

Was this information helpful?

flower leg pool crochet gladiator wedding long chain RINGS beach knee leglet sandals leggings boots lace EXOTIC barefoot high qHd7w5Zp

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA Eur38 Size Shoes USA Women's Heel Block Sandals 90's Stretch in Shoes Strappy Fisherman 5 Vintage Brown US7 Elastic 5 5 the 7 Made UK5 qSpWcfSA
90's vintage brown leather and elastic strappy fisherman sandals with mid high block heel, tapered toes, leather interior. Comfortable, simple, well made right here in the USA. Perfectly clean inside and out with no flaws, appear barely worn. Lovely!