Drill through Filters

Get the required Data Tables from here, viz. DimDate, which contains the date of sales sorted out according to month, day and year, etc. DimCustomer, to get information about customers such as their first name, last name, gender, marital status, etc. DimGeography to get the demographic details of the customer. FactInternetSales is a dummy model of sales through the internet and related customer data. and FactResellerSales to extract the same information about the resellers. Select DimDate, DimGeography, FactInternetSales, and FactResellerSales hierarchical data tables. And load the data model.

The data model will be loaded in less than a minute.

You may designate a destination target page in your Power BI report that focuses on a particular entity, such as a supplier, client, or manufacturer. Right-clicking a data point on one of the source report pages will take readers to the target page, where they can read the information filtered for that context. Power BI Desktop or the Power BI service both allow you to set up drill-through in your reports.