Forum Discussion
Compare two sets of data
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
Thanks, I tried that, but couldn't get it to visualize or slice correctly.
The merge worked, and I'll mark that as a solution.
To add more detail, in case I'm missing something, I really had three fields. The data was like this:
Table Mark
Year, Person, Measure
1, Mark, 23
2, Mark, 24
3, Mark, 18
Table Steve
Year, Person, Measure
1, Steve, 22
2, Steve, 26
3, Steve, 19
When I try to create a relationship on year, it says I have this, but I can't get both items on the same chart. If someone has a good tutorial or blog link, I'd appreciate it. I don't like the merge/append