Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Debit column of #s from my power query table show as blank in pivot table

Copper Contributor

My "citi" pivot table is displaying blank fields from the Debit column (which should, instead, be displaying #s), although it correctly displays #s in the credit column (which pulls data from my "citi" power query table).

 

Both debit & credit #s display correctly within the pivot table in the "rows" section, but not under the columns section (of pivot table)

 

Both debit & credit columns are formatted the same (ie. currency within pivot table and numbers under properties of pivot table). How do i get the credits to display on my pivot table?

 

https://prnt.sc/5k-zA7tUXEtA 

 

adlbrk720_0-1707150227034.pngadlbrk720_1-1707150430064.png

 

adlbrk720_2-1707150627834.png

 

2 Replies

@adlbrk720 

As variant - if you add data to data model creating PivotTable and at least one value in the column is text, entire column in data model will be considered as texts. Sum of the will be blank.

Thanks@Sergei Baklan but if that were the case then my "credit" column (in power query) which shows text "null" would also not display in the pivot table column (which it does)

 

adlbrk_0-1707155631568.png

 

adlbrk_1-1707155671180.png

 

 

or, for that matter in the "rows" section (which it also does)

adlbrk_2-1707155727592.png