Forum Discussion
PowerQuery - additional fields
Hey TatianaH, you may want to try this:
Right click on your pivot table, go to "PivitTable Options...", nevigate to "Data" tab. In the drop down below, choose "None", then close the window. Refresh your pivot table and the drop-down list should be refreshed.
Let me know if that helps!
when you put a measure in the value area, PivotTable will automatically filter out the columns which get blank values in all rows.
Thank you for your response. I opened the PowerQuery Editor and double-checked for any blank values. I don't show any in the Value column. I also looked at the Source column (screenshot below).
Thank you.
Hey TatianaH, you may want to try this:
Right click on your pivot table, go to "PivitTable Options...", nevigate to "Data" tab. In the drop down below, choose "None", then close the window. Refresh your pivot table and the drop-down list should be refreshed.
Let me know if that helps!