Forum Discussion
Multiple riverflow time series on one graph
How do you create multiple daily time series plots on one graph in powerbi? E.g Mean daily riverflow data of multiple years on one graph in Power BI. Where the daily average flow data is on the y-axis and the date on x- axis. Overall, comparing last year to this year, but for daily mean data. thanks
Hi Mikekeji1978 To do this in Power BI, extract Year and Day of Year from the Date column using Power Query. Use a line chart with Day of Year on the X-axis, Daily Mean Flow on the Y-axis, and Year in the Legend to differentiate lines. Ensure the X-axis granularity is set to "Continuous" for smooth daily comparisons.
3 Replies
Hi Mikekeji1978 To do this in Power BI, extract Year and Day of Year from the Date column using Power Query. Use a line chart with Day of Year on the X-axis, Daily Mean Flow on the Y-axis, and Year in the Legend to differentiate lines. Ensure the X-axis granularity is set to "Continuous" for smooth daily comparisons.
This worked for me. Although the x-axis date is not showing as an individual date(01/02/2024) but as a number (from 1 to 365 days). What matters is that I can view multiple lines on one graph. This solved the problem. Thank you so much
Akash_Varuna Great! I will also try this. Thank you so much
