Forum Discussion
Bar Chart with Multiple Tables as DataSource
I'm trying to build a Bar chart with 2 axes. For Example: X = The Branch Name Y = Total Sales It sounds incredibly simple but i cannot seem to figure this out. First off there is no...
Hi,
two general strategies for solving this:
In Power Query, merge the neccessary fields together into a new table, and use this table as source for you chart.
Or,
create a stand-alone table, with names corresponding to e.g. the filenames on the rows. Then create a measure that makes use of the Switch-statement, so if the row value corresponds to input table 1, use the sum of column 1 in table 1, and so on for each row/inputfile. Then add the column of the stand-alone table as axis, and the measure as value.
If you provide som sample data, I can help you in more details.
best regards,