Loading in varying columns in graph dynamically

Question

Hi all,&nbsp;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 there are some columns that are named distinct depending on the data sheet.&nbsp;This made me wonder if there is a way to dynamically select these columns in some way and automatically show them in a graph when adding the dataset to the project. At this moment I have two solutions but I do not know if they are possible in Power BI, these solutions are:&nbsp;1. I have noticed that all those columns are numeric fields, so maybe I can just select all numeric fields and put them in a graph (if that is even possible).&nbsp;2. Another option would be to foreach over the column name and check if they contain a certain keyword, but I wouldnt know how to do this either. And then dynamically add them as values in the graph&nbsp;Are these options possible in Power Bi or are there better ways to achieve my goal?&nbsp;&nbsp;

stefanogrimaldi · Accepted Answer

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,&nbsp;
this can be done on power query

Forum Discussion

Loading in varying columns in graph dynamically

2 Replies

Related content

The loading speed of embedded reports varies across different regions

Product ids of varying length

Isinscope - varying distinctcount

Dynamic Filter

Microsoft Load