Display Drill Through (Debit Amount) using Actual & Actual LY

[Tsrivastava]

Main Page

When click on Actual in Main Table data drill through as Debit Amount for CY but when i click on Actual LY to Drill Through i Want Debit Amount to Drill as Actual LY on the same report  

[v-easonf-msft · Accepted solution]

Hi, @Tsrivastava 

Unfortunately, PowerBI does not support drilling based on specific fields in the table.

As a workaroud, you can setup two drill-through pages (add the fields "Actual" and "Actual LY" to the drillthrough panes on the respective pages)

That way, you can selectively jump to pages to view Actual Data for CY or Actual Data for LY.

Best Regards,
Community Support Team _ Eason

[VijayP]

@Tsrivastava 

Drillthru shows the values which are created by you in your drill thru page, it will not hide any thing based on selection. So you need to have both values CY and LY in the report so that you can see values accordingly!

Drillthru is decided based on the drillthru Field , not based any measure