Forum Discussion
MartijnBre
5 years agoFrequent Visitor
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...
- 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
StefanoGrimaldi
Resident Rockstar
5 years agoeither 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