2 sets of data in 1 stacked graph

[Daniel_B]

Hi

I'm trying to work out what the best way to see 2 lots of comparable data in the same chart (Stacked Chart)

The data I am trying to compare comes from 2 tables (Table 1 and Table 2) and both tables contain locations (6 identical matches but table 2 has 1 extra location which doesn't need to be included in the chart) and a folder of measure with a count of the 1 to 5 star ratings

I would like to see the stacked chart with the Location as the Axis and the values for the count of 1 to 5 star ratings next to each other so that I can see if the same location has any correlation between Table 1s ratings and Table 2s ratings 

I tried linking the tables at the location level but that has just yielded a single bar by location with all 10 measures showing (5 for table 1 and 5 for table 2) 

What's the best way to do this and do I need to add any special visualisations for this?

Thanks

[v-lili6-msft · Accepted solution]

hi  @Daniel_B 

I think the best way is that use create a relationship between two tables by locations column, (you'd better add a dim locations table and then use it as a bridge to create the relationship between two tables) 

then use the dim locations table field as the X-axis and other values from two tables.

Regards,

Lin

[amitchandak]

Can you share some sample data.

I think you should combine data using union.

Union with selectcolumns, summarize or addcolumns