Combine multiple tables into one chart

[Anonymous]

Hi,

I'm trying to combine multiple tables into one chart. For every table I get the count of the unique numbers but then it shows like this. It's not looking good as it is still segregated by every item in each table.

Is there a way that I can create a new table, and get just the count of value from each table like this?

Item      |   Value

Table1   |  100

Table2   |  40

Table3   |  76

[amitchandak · Accepted solution]

@Anonymous ,

New Table =union (
summarize(table1, "Name", "Table1", "Value", sum(Table1[value])),
summarize(table2, "Name", "Table2", "Value", sum(Table2[value])),
summarize(table3, "Name", "Table3", "Value", sum(Table3[value]))
)