- Open the Excel sheet with your PowerPivot dashboard.
- Select PowerPivot tab in the Ribbon.
- Press the button PowerPivot Window button to launch the PowerPivot window.
- Select the table or view on which a column is added
- Press the button Table Properties.
- Be sure to select Column names from Source.
- Scroll to the right. At the end you will see the new added column. Select this column. In this example Zipcode
- The added column ZIPCode is now added to the PowerPivot Window.
- Select the Excel sheet with you rPowerPivot dashboard.
- Show the Field List.
- The PowerPivot Field list has detected that a change is made. Press the refresh button.
- Select the Data tab in the Ribbon of your Excel sheet and press the refresh all button. This update your excel sheet with the information of the added column.
- Now look in the PowerPivot Field List and you will see the added column in the table or view.
Enjoy using your PowerPivot dashboard with the new column(s)
2 comments:
Hi Andre,
Thanks for taking the time to help other users out there. Much appreciated.
I am trying to find a way to add additional columns via the 'Paste Replace' method. I am wondering if you would know how to achieve this?
More info:
1. Original data set was pasted directly into a powerpivot table. (I don't know if this is best practice)
2. My data source has since been modified and I need an additional column of data
3. If I add a column and try to 'Paste Replace' I get the error that number of columns pasted doesn't match
Thanks,
Sriram
Nice blog has been shared by you. it will be really helpful to many peoples who are all working under the technology.thank you for sharing this blog.
Ms excel training in chennai
Post a Comment