horizonblue
New Member
- Joined
- Dec 7, 2023
- Messages
- 16
- Office Version
- 2010
- Platform
- Windows
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.
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.