cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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   :

 

Capture-1.JPG

 

 

İ 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.

 

Erhan 

2 REPLIES 2
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.

 

Regards,

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: | |