Pivot Table Blank Text

[horizonblue]

Hi!

I have an power pivot table, that is feeding off a power query data set.

My pivot table has a column called WorkOrders, this contains solely text. This column currently shows as blank despite having data coming in from power query. If I go to field settings and tick show items with no data, then all the text shows but the rest of the pivot tables data disappears.

Is there anyway to get all the text to show along with all the other data.

 

[RoryA]

Where did you put that field in the pivot table?

 

[horizonblue]

Where did you put that field in the pivot table?

Hi, I put it into the rows field.

 

[RoryA]

And what is in the values field area?

This will probably be easier to help with if you can share a link to the file, or at the very least some images of your pivot and the data table.