Forum Discussion
Solved
Compare two sets of data
This is probably simple to do, but I'm struggling a bit to compare two sets of data that have similar structures in a single chart. I'm obfuscating, but let's say I've got a set of data for perso...
Try and merge the data together in Power BI or upstream so it looks like this:
TimePeriod, WeightA, PersonID
1, 190 ,A
2, 192 ,A
3, 195, A
4, 194, A
5, 196, A
1, 180,B
2, 182, B
3, 185, B
4, 184, B
5, 186, B
Ideally, you should append those 2 datasets, with one more column specifying person. So now, your table structure will look like
Person, TimePeriod, Weight.
Once you have this, you can put the TimePeriod on axis, Person on Series/Legend and Weight on Values, and then you will get a line chart that can be used for comparison