Drill Down Into Related Table Power. Box 1 indicates the drilldown path in our case Category - Segment Box 2 highlights the new Drilldown toggle when its ON clicking on a chart element will drill down when its OFF clicking on a chart element will act as a filter and Box 3 is a new icon that allows to drilldown without clicking on individual element of a chart. Under the Format image pane set the Action slider to On and then set the Type to Back.
Click on the Quick Explore icon. The workaround consists of building your own drill-through. Now click on any category vertical bar to drill down at sub category level to drill down at product level click on any sub category vertical bar.
Your image now functions as a back button.
If I build an Excel Pivot Table using that data model then show the measure GrossSales in the pivot table then double click on that measure in the Pivot Table Ill get a drill down report. From the UI you can select Drill Down To Table. So this is where the drill-down feature of Power BI plays a crucial role in showing up detailed drill-down insights. The chart is presented with a person hierarchy.
