Forum Discussion

MartijnBre's avatar
MartijnBre
Frequent Visitor
5 years ago
Solved

Loading in varying columns in graph dynamically

Hi all,   I have the following problem. For a project I want to make a template dashboard that can be used for different data sheets (excel files in this case). Most of the data looks alike, but th...
  • StefanoGrimaldi's avatar
    5 years ago

    either wont work cause you talking about changed that have to happend no the query side or the source, ummm you can create a second sheet with the columns renaming, get teh data transpond tha table, make a change value of the column name that convert to rows them transpond again and use first row as headers, 

    this can be done on power query