Multiple Time Series on Single Line Plot

[Anonymous]

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) on the same line plot based on ranges selected from two slicers. Has anyone figured out a way to do this? Thanks in advance for any help.

[v-yuta-msft · Accepted solution]

@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.