Forum Discussion

Mikekeji1978's avatar
Mikekeji1978
Regular Visitor
1 year ago
Solved

Multiple line chart visualisation

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-axi...
Need Help
  • Mikekeji1978's avatar
    Mikekeji1978
    1 year ago

    The issue has been resolved following one of the responses given. Many thanks

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi Mikekeji1978 ,
To create multiple daily time series plots on one graph in Power BI, you can use a Line Chart visualization. First, ensure your data includes fields like Date, Year, and Mean Daily Flow. You’ll need to create a new column that extracts just the Month and Day from your Date field (ignoring the year), so you can align daily values from different years on the same x-axis.

 

You can create this column in Power Query or DAX, for example using FORMAT([Date], "MM-DD"). Then, plot the new Month-Day column on the x-axis, Mean Daily Flow on the y-axis, and use Year as the Legend to create separate lines for each year. This way, you’ll be able to compare daily riverflow patterns across different years on a single chart. Make sure to set the x-axis to be "Categorical" instead of continuous to properly display all dates without aggregation issues.