Showing results for 
Search instead for 
Did you mean: 
erhang Regular Visitor
Regular Visitor

Changing Column names

Hi Dear Power Team ;



İ need your help about below issue.


İ have a table in excel as below   :





İ created a dashboard with a matrix table on power bi and show that table on dashboard.

My problem is when the column names changed the table is not working.

İ am always looking for per 3 months on the table.

For example after i created that table this month  , next time i will check for the months : July,August,September  so in excel in A column will be July and then B column will be August and then C Column will be September.


So is there any way when i change the column name in excel in my dashboard the names will change automaticly too.Also in my table in power Bi too.


thanks for your kindly supports dear friends , i will wait for your infos.



Super User
Super User

Re: Changing Column names

You might consider just pulling in 12 months of data every time and filtering it out correctly in Power BI.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Changing Column names

Hi @erhang,


I think you can unpivot columns to convert column to list, I think unpivoted table can simply to calculate in dax formula.

Unpivot Data Using Excel Power Query


Current power bi not contains features which you wanted.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |