Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple Time Series on Single Line Plot

Hello,   I have one dataset with a time stamp and flow rate data. I'd like to compare two separate periods of time (i.e. one week of December flow rate data and one week of November flow rate data)...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    In query editor-> click Transform-> click on the date/month column-> Unpivot date/month column, then you will get two new columns [attribute] and [value].

     

    Then put the [attribute] in legend field, put the [value] in Y-axis field, put another column in X-axis field.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

In query editor-> click Transform-> click on the date/month column-> Unpivot date/month column, then you will get two new columns [attribute] and [value].

 

Then put the [attribute] in legend field, put the [value] in Y-axis field, put another column in X-axis field.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.