Forum Discussion

Frequent Visitor

5 years ago

Solved

How to handle data source column headers changing?

Hi, Each month I recieve a .csv file where each row represents a material that we order from a supplier and columns 7 and onwards represent the forcast for each month, starting with the current m...

Anonymous
5 years ago
Hi Sam_Bolsover ,

It is suggested to unpivot two column in Power Query, then select the attribute field for you title.

Reference:https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles#select-your-field-for-your-title

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How to handle data source column headers changing.pbix31 KB

Super User

5 years ago

As I suggested, you're going to want to choose 'Unpivot other columns' if you want the solution to be dynamic. If you choose unpivot columns it will break when a new month of data comes in.

Frequent Visitor

5 years ago

Thank you Kim, I will keep this in mind.

Best regards,

Sam Bolsover