Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Daniel_B
Helper II
Helper II

2 sets of data in 1 stacked graph

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

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

Can you share some sample data.

I think you should combine data using union.

Union with selectcolumns, summarize or addcolumns

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.