cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

Cheers,

Anton

Status: New
Comments
Super Contributor

@afernando

 

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,

Herbert

Regular Visitor

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.

Super Contributor

@afernando

 

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

 

Best Regards,

Herbert