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....
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!
It worked! Thank you JingerL.