Using Drill-through
Usually, the information displayed in Power BI reports is aggregated and summarized, often to show more information and provide a global context of what is being presented. However, some users may require a deeper level of detail within the report that allows them to delve further into the data.
To achieve that higher level of detail, you can use Drill through to get to another page where more detailed information is available. To do this, you need to configure the page you want to use. This can be done by going to the Visualizations pane and adding the columns that you want to use for filtering this detail page. When you add a column in the Add drill-through fields here field, you can choose to use the column as a category or as a summarized value.
In the example shown in Figure 8.44, I created a page with a bar chart displaying the average rating of Airbnb apartments by neighborhood in New York City. On the detail page, I have added the neighborhood column...