Forum Discussion

way0utwest's avatar
way0utwest
New Member
10 years ago
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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    10 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi way0utwest,

 

   you want to compare these two dataset in a chart showing two lines right?

Because if you do not want to merge the two dataset, you can just add a relationship between them:

 

 

Then using the Line Chart visualization you can plot this:

 

to observe the changes between them.

Let me know if it works.

 

#I'M Not An Expert#

  • valQuentine's avatar
    valQuentine
    Frequent Visitor
    9 years ago

    Can you toggle ON/OFF the compared charts? Say, I want to show one dataset in the same chart and compare it with another (with the option to turn it ON/OFF).