Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 in that area of the report". 

The fields that I'm trying to add are decimal values and I can add them without an issue when I'm directly connected to the database from Excel. 

I can't think of anything that's causing the issue. Any help is appreciated. Thanks




Status: New
Microsoft Employee



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.


cannot add a field to values section on a pivot table in Excel_1.jpg 


Best Regards,


Not applicable

Thanks for the comment @v-haibl-msft . Pardon me if I'm asking a silly question. My understanding is that 'measure' is a single value. So how can I use a 'measure' instead of a field? And how can I create a measure to imitate the field that I'm trying to add? 


Thanks in advance.

Microsoft Employee



Please refer to this document about how to create a measure in Power BI Desktop.


Best Regards,


Frequent Visitor

Creating measures is not a challenge but what's the rationale for this? It's extremely inefficient if I have to create a measure for every field I want to use as a value in my pivot table. The fields already exist in the database and they are already assigned as SUM fields. This is completely backwards and makes the Analyze in Excel feature useless in many cases. @v-haibl-msft can you please explain the technical reason for this?


New Member

let me support @mickjaeger question

New Member

I agree.  This is silly and makes the analyse function pointless

Regular Visitor

in my case I have all my fields as numeric so why I still need to declare as measures. I may want to use same numeric field as average or sum or count or with statistical function. so why is it has to be decaled as measure.