PowerQuery - additional fields

[Anonymous]

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.

[Anonymous]

It worked! Thank you JingerL.

[wdx223_Daniel]

when you put a measure in the value area, PivotTable will automatically filter out the columns which get blank values in all rows.

[Anonymous]

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.

[JingerL · Accepted solution]

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!