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

Cookistador's avatar
Cookistador
Super User
1 year ago

Hi Mikekeji1978 

 

First, you need a Calendar/Date table, then you just have to use some Time

intelligence function

If you do not have one, you can create one calculated table with Calendarauto() function

 

For example with DateADD

 

Average Flow X Years Ago =
CALCULATE (
AVERAGE('RiverFlowData'[FlowValue]), -- Or your base daily mean measure logic
DATEADD('Dates'[Date], -X, YEAR)
)

 

You just have to replace X by how many years ago you need to compare

And of course, you can create this measure many time as you need and add all of them on the y-axis of your chart

Mikekeji1978's avatar
Mikekeji1978
Regular Visitor
1 year ago

Not sure if i will need the average function because I just want to use the time series as it. I am not calculating any average. I will go for the base daily mean measure logic. I will try that. Thank you.