Drill down and drill down reports in Power BI

Drag and drop the sales amount from the Power BI Fields section to the canvas to automatically create a column chart, as shown in the following screenshot.

Next, let me add the product hierarchy to Axis to create a column chart showing the sales amount by product category.

Let me apply a quick format to this column chart.

NOTE: I suggest you check out the Column Chart Format article to understand the formatting options.

You can perform the Power BI Drill up and Drill down report action using any of the three options.

1. Go to the Data / Exploration tab to view these properties
2. If your data has multiple levels, these buttons are displayed in the upper left corner.
3. Right-click on the report to display the context menu. You can use this menu to select the levels.

NOTE: There is a difference between the next level displayed and the breakdown. Show next level shows you the full data on the next level, but the Drill down option shows you the selected data

Let me select the button Go to the next level in the hierarchy in the upper left corner of the report.

You can now see the Sales by Product subcategory (level 2). If you look closely, the Drill Down button on the ribbon and the upper left corner is enabled. It is because there is a possibility to go up (product category level)

This time, we use the context menu. Let me select and right click on any column and select the Show next level option

You can now see the column chart showing the sales by product color.

This time, we click on the Show next level on the ribbon of the Data / Exploration tab.

Now you can see the sale amount per product. It is the last level in a hierarchy and that is why the Show next level button is disabled.

Drill down reports in Power BI

Click the Drill down button in the upper left corner of the Power BI report.

You can now view sales by product color.

Let me select any random column and select the Explode option from the context menu.

You can now see the Sales by Product subcategory. Let me press Drill up in the ribbon

You can now see the column chart showing sales by product category.

Detailed reports in Power BI

Select the Power BI column you want to drill down into and right-click to open the context menu. Let me select the Drill down option in this Power BI report.

You can now see the column chart showing the Sales by Product subcategory. However, this is only displayed for the Bicycles category (not Accessories or Clothing). If you look closely, Power BI added the bikes in the filter section.

Let me select the road bikes and click Dig Deeper

You can now view road bike sales by product color

Click the Drill up button in Power BI to go to the previous level

Click the View Data button to see the data we used to create this report.