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
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
Solved! Go to 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
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
Can you share some sample data.
I think you should combine data using union.
Union with selectcolumns, summarize or addcolumns
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |