Forum Discussion
Column names change automatically
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 , 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
2 Replies
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