Forum Discussion

Sam_Bolsover's avatar
Sam_Bolsover
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
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.

Sam_Bolsover's avatar
Sam_Bolsover
Frequent Visitor
5 years ago

Thanks Stephen,

 

I think this approach can get me what I want if display the data as a matrix instead of a table. 

 

Best regards,

Sam Bolsover

  • KNP's avatar
    KNP
    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. 

    • Sam_Bolsover's avatar
      Sam_Bolsover
      Frequent Visitor
      5 years ago

      Thank you Kim, I will keep this in mind.

       

      Best regards,

      Sam Bolsover