Forum Discussion

gco's avatar
gco
Icon for Resolver II rankResolver II
7 years ago

Drill-through using multiple filters

i have 2 tables, CUSTOMER(AccountNumber,Balance,ProcessDate), and ACCOUNTS(AccountNumber,Transaction,ProcessDate).  On page 2, i added to the drill-through filters, the CUSTOMER.AccountNumber and CUS...
Need Help
gco's avatar
gco
Icon for Resolver II rankResolver II
7 years ago

Hi v-frfei-msft,

 

Thank you for replying.  I did try your suggestion and that is how i was doing it too, but only the account number is being filtered in Table 2.  I am not able to tie the Process Date on Table 1 with Table 2.  Is it possible to also set Table2_ProcessDate to filter by Table1_ProcessDate?

 

 

Thank you

Glen

gco's avatar
gco
Icon for Resolver II rankResolver II
7 years ago

v-frfei-msft ,

 

I have uploaded a test pbix file in the link below.  I am wondering if you can look at it.  In this report, i have 2 tables, Detailed_Trans and Transactions.  On page 1, i have a view that displays everything from the Transactions table.  And i have a drill through setup on page 2 for AccountNumber and ProcessDate, and a view displaying Detailed_Trans.  I have relationship between table 1 and 2 via AccountNumber.  And the view on page 2 is only being filtered by Account Number.  I cannot seem to figure out how i can filter the view for both Account Number and ProcessDate.

 

https://kcuboard-my.sharepoint.com/:u:/g/personal/gco_kitsapcu_org/ETIBPswvPQxPr4B5rUiJ9ucBQGbyFLQfJibCRbXaueE42Q?e=hzB8QT

 

Thank you

Glen