Drillthrough in Power BI Report

[AnilKumar]

Hi All,

We build a report with Financial Year wise Income and Expense. Initially We represented that in the matrix Visual. But due to customer requirement, We changed the View to 2 Successive Years Difference with in the Matrix visual.(Used measures to get the differences). But when I Drillthrough the report by selecting  18-19, Income Factor, It is showing all years data with Income factor filtered. Could any one help on this?

Thanks & Regards,

Vishnu Priya.

[v-qiuyu-msft]

Hi @AnilKumar, 

From your description, it looks like the drillthrough filter can only filter Income data instead of Expense, right? 

Please check if you create a measure to calculate Expense values and there is any function like All() to ignore filters. If the Expense is a column not a measure, please check if the column used for drillthrough filter has a active relationship with the Expense column.

Best Regards,
Qiuyun Yu