Forum Discussion
Solved
Visualising Multiple Time Series Datasets on 1 Graph
Hi, I'm getting started with Power BI, and am trying to use it to overlay two sets of time-series data on a line graph. The data is in seperate tables, with a time/date reading (01/01/2018 00:00 ...
I would say that the correct way to do this would be to have a third table of all of your time values. You can create this by creating a calculated table like this:
TimeTable = DISTINCT(UNION(DISTINCT('Table1'[Time]),DISTINCT('Table2'[Time])))Relate this to your other tables in the obvious way. Use this table as your x-axis.
I would say that the correct way to do this would be to have a third table of all of your time values. You can create this by creating a calculated table like this:
TimeTable = DISTINCT(UNION(DISTINCT('Table1'[Time]),DISTINCT('Table2'[Time])))
Relate this to your other tables in the obvious way. Use this table as your x-axis.
Thanks Greg, that worked a treat!