Status:
New
cannot add a field to values section on a pivot table in Excel
I am trying to create a pivot table from an Access database connected to PowerBI. Sadly I can't add any field to the values area as I keep getting the error "The field you're moving cannot be placed ...
v-haibl-msft
Microsoft Employee
Microsoft EmployeeAnonymous
Are you using “Analyze in Excel” function? I think you can take a look at this thread which has the similar problem with you. You need to drag Measure into Values field but not normal fields.
Best Regards,
Herbert