Add Drill-down To A Power View Chart Or Matrix - Microsoft Support
Maybe your like
Add drill up/drill down using an existing hierarchy
This example explains adding drill up/drill down to a matrix. Drill up/drill down can also be added to bar, column, and pie charts.
The nice thing about having a hierarchy that already exists in the data model is that you can use it over and over in lots of Power View sheets and reports.
-
Create a visualization using an existing hierarchy. Hierarchies in the field list have an arrow for expanding and collapsing the hierarchy components. Clicking the hierarchy adds all of the component fields to the visualization as a table.
-
Convert the table to a matrix or chart. From the Design tab > Switch Visualization > Matrix.
-
To enable drill-down, collapse the matrix. From the Design tab > Show Levels > Enable Drill Down One Level at a Time.
-
Double click a top-level hierarchy field. For example, in a Sports-Disciplines-Events hierarchy, click the sport of Aquatics. This drills down to the next level in my hierarchy and displays the four events that make up the sport of Aquatics: Diving, Swimming, Synchronized S., and Water polo.
-
Drill down further by clicking one of the fields. Clicking Synchronized S. drills down to the Events level in my hierarchy and displays duet, solo, and team.
-
Drill up by clicking the up arrow.
Top of Page
Tag » How To Drill Down In Excel
-
Drill Into PivotTable Data - Microsoft Support
-
Drill Down Options - Excel 2016 Pivot Table - YouTube
-
Excel Pivot Chart Drill Down - CustomGuide
-
Create A Drill Down Experience In Excel - Online Excel Training
-
Excel Pivot Table DrillDown Show Details - Contextures
-
Drill Down Option In Excel Pivot Table.
-
Create An Excel Report That Can Drill Down To Display Detail - DataWright
-
Drill Down In Power Query - Bi Unija
-
How To Automatically Drill Down Data In Excel On A SINGLE Click
-
Drill-Down Into A Pivot Table - Excel Dashboard School
-
Drilldown - Sharperlight
-
Using Drilldown | Velixo Help Center
-
Drill Down Or Drill Up In The PowerPlay Worksheet - IBM
-
NVision Drill Down For Excel 2016 - OIT - Knowledge Base