Column names change automatically

[Anonymous]

Hello,
I'm working on a simple forecast data to produce some visualization. I got to the point where I have the Data in the below format to create my visualization (Promoting the first row as header)

The problem I find is the following month, when I pull a new report, all the columns 5 to 10 names will change as the month has progressed, and my visualization breaks, having to remove the first month, and add the new month (with all the correspondent formating etc)

How can I setup my visualization to use Column5 to Column10 as part of the Dataset, but in my visualization, display the column title with the correct name of the month

Regards

David

[Anonymous]

Thanks, I never though about that trick.
I now need to format a bit my visuals but I see the potential and it solves all my problems.

Thanks

[amitchandak · Accepted solution]

@Anonymous , based on what I got.

Do not rename, Use the first row as the header.

Select all the columns other than a month and use unpivot other columns and then use the data, it should work better

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw