Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am running my financial dashboard and as one year is now completed, I am trying to replace my budget for a new one. So, the budget column heads used to be called 1/1/2017 and now this is changing to 1/1/2018. However, if I change the header, the update will give me an error saying that the column header has changed. I need to change the header because my comparison between budget and actuals will not work as I change the year to 2018. Any tip on how to change the header and make Power BI to accept the new header name?
Solved! Go to Solution.
Hi @Jawed,
I would suggest renaming columns in the Query Editor where is dedicated to shape data (customize). If we change the column name in the source, some steps that cite the column name directly could be destroyed.
Best Regards,
Dale
Hi @Jawed,
Where did you change the column header? I would suggest you change it in the Query Editor by adding a new step.
Best Regards,
Dale
The name changes were made on the spreadsheet where the data is pulled from as the new data relates to the new year. However, the rest of the data structure is the same. Would you suggest that I rename both the columns in the Power BI and the data spreadsheets?
Hi @Jawed,
I would suggest renaming columns in the Query Editor where is dedicated to shape data (customize). If we change the column name in the source, some steps that cite the column name directly could be destroyed.
Best Regards,
Dale
Thank you, @v-jiascu-msft. I'll leave the source column as they are and rename them in the editor.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |