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 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.
1 Reply
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,
