Bar Chart with Multiple Tables as DataSource

[Anonymous]

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 not just a simple Bar Chart, only Stacked, and Clustered, at least from what i can see. 

I am able to get data from Table A in place.

But I cannot add any other Tables' information in place or else it flips out. 

How can i simply create 10 Bars and feed it 1 column from 10 different Tables. 

Note:

These tables are populated by .csv files that are updated every week. 

[sturlaws]

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,