Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |