Configure Bar Chart using multiple tables/excel sheets

[Bbrown44]

Hi everyone,

I am trying to configure a bar chart where percentage values and x axis can be configure from multiple sheets.  For example, below is the snapshot of what I would like to acheive which I was able to do one only useing 1 table.Targeted Visual

When I try to recreate this visual using multiple tables, there is not a formatting tool to put the legend into the x axis.  I need to use multiple tables so I can leverage the drill through feature for each individual bar.

See example below.

 is there a way to create a x-axis using variable from multiple tables/sheets?

Please advise.

[v-chuncz-msft · Accepted solution]

@Bbrown44,

You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.