Skip to main content

Power BI

New

Enable drillthrough on more than one dimension

Vote (11) Share
Ivar Gjerde's profile image

Ivar Gjerde on 26 Sep 2017 17:27:57

Currently, drill through only works on one dimension. E.g. I can have a report where I can drill down on store location, if I then drill further, e.g. on product group the store location will be reset and I will see the product group page displayed for all store locations.

It would be great if it was possible to bring the store location filter through to the product group page e.g. by dropping the store location dimension into the drill through filters box on the product group page.

There could also be a check that a value has to be sent for all filter contexts for a page to show up in the drill through right click dialogue box. This would mitigate the risk of a user navigating to the Product Group page directly from the first page where they can drill through to the store location page (without having selected a product group).

As a report designer I could then decide whether I want to drill through to the Product Group page with the Store Location filter applied or not by adding/not adding the Store Location to the drill through field on the Product Group page.