Forum Discussion

kest's avatar
kest
Frequent Visitor
9 years ago
Solved

Plotting multiple series in a line chart

Hey guys   I'm trying to visualize two lines in a chart.   Line 1 is followers of our first social media account, while line 2 should represent our other account. You see both variables under Fie...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    Actually I misspoke you will want "Append Queries". Go to the query editor and you will find the "Append Queries" on the Home tab on the far right:

     

     

     

     

     

    You will be asked which tables you want to append (one to the other, assuming they have the same columns).

kest's avatar
kest
Frequent Visitor
9 years ago

Thanks for your reply, David.

 

I masked the confidential parts of the data so here we go with what I have right now:

 

 

Followers (Z) is my value, Date is my axis and profiles is my legend.

 

Both Z and X are linked to profiles which is the legend, so this could serve as the identifier.

 

How can I now merge the tables and display Followers x?

 

I'm sorry, I have never merged tables in Power BI before.

 

Best,

Kevin

 

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
9 years ago

Actually I misspoke you will want "Append Queries". Go to the query editor and you will find the "Append Queries" on the Home tab on the far right:

 

 

 

 

 

You will be asked which tables you want to append (one to the other, assuming they have the same columns).

  • kest's avatar
    kest
    Frequent Visitor
    9 years ago

    You are my personal hero, Sir.