Excel pivot table linked to Power BI - can't see date field in detail

[kessinger]

I've linked from excel to Power BI and the functionality works great.  However, when I click on a total number in the pivot table to pull up the detail, the new sheet does not contain the transaction date, even if I use that in the pivot table.  It contains a lot of other fields, including account code, description, etc.  How do you select fields to show up in the detail?

Thanks.

Kevin

[v-jiascu-msft]

Hi Kevin,

It seems the Pivot table of Excel works in a different way comparing to Power BI. The Pivot table can drill to the details that have relationships with the current value. For example, the current table, or other tables related to the current table. Please refer to snapshot below. You can choose which one to drill to.

Best Regards,

Dale