Forum Discussion
PowerQuery - additional fields
Good afternoon,
I have a question in regards to the Dropdown menu in PowerQuery. For example, I would like to filter by the Source column in my Pivot Table. I am able to do so without any issues. When I move the Source to the Column section of the Pivot Table, I get additional fields that are not supposed to be there. Please let me know how to get rid of the additional information.
Filter
Column
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!
4 Replies
when you put a measure in the value area, PivotTable will automatically filter out the columns which get blank values in all rows.
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!
