Skip to main content

Power BI

New

Use drillthrough filters as filters in report canvas

Vote (33) Share
TonDeli's profile image

TonDeli on 11 Sep 2017 17:56:09

Feature to use same dimension as filter in your report page. When you use drillthrough feature and you end up to a new report page. Your action has selected a value for drillthrough filter. If you use same dimension as a separate filter visual it only contains the same value as drillthrough filter. You need to clear drillthrough filter value first and start exploring your data after.

Comments (3)
TonDeli's profile image Profile Picture

7d0bab1b 7a7e-4bf5-975d-63ddec5d3c51 on 05 Jul 2020 23:34:13

RE: Use drillthrough filters as filters in report canvas

Totally agree with Joel and TonDeli! It's basic behaviour in any reporting tool and can't find any useful workaround to the problem.

TonDeli's profile image Profile Picture

a92640e2 9aa9-4bbe-ac79-fd46e98c9402 on 05 Jul 2020 23:26:40

RE: Use drillthrough filters as filters in report canvas

Can't believe there are not more votes for this. Drillthrough is still lacking due to how the drillthrough filters are applied in the Filter Pane which are not connected to slicer filters and cannot be cleared without clicking "back" or manually clearing them from the filter pane.

TonDeli's profile image Profile Picture

a92640e2 9aa9-4bbe-ac79-fd46e98c9402 on 05 Jul 2020 23:06:10

RE: Use drillthrough filters as filters in report canvas

YES! This is very confusing and frustrating that the drillthrough filters are NOT tied to other filters. Eg. drillthrough a value, but the slicer does not filter accordingly. As stated in the idea, you must clear the drillthrough filter first before you can filter with slicers or other visual filters.

There are several ideas now posted relating to the shortcomings and issues with how DrillThrough was implemented. Please provide fixes/improvements.