Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 for example) and a temperature reading for each.
Adding the values from the first set of data is easy, it gives me a line graph as I'm expecting with the average temperatures for each day. However, when I attempt to add the second series of data to the graph, Power BI just plots this as the average of all of the values, not the daily averages. See screenshot below.
I would appreciate any pointers or help with this. Thanks in advance!
Solved! Go to Solution.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
44 | |
40 |