Data table arranged in Date in one column and time in another column

[Mramono]

I have a table with (Date : Time : Value) date in days 08/08/2025, Time in hours 00:00 and the values for that particular time. How can i set up my power bi model so i can plot date and time vs the Value

Production Date	Time	Value (-250um%)
01-Jul-25	13:00:00	74.12
01-Jul-25	14:00:00	74.12
01-Jul-25	15:00:00	73.46
01-Jul-25	16:00:00	73.46
01-Jul-25	17:00:00	64.11
01-Jul-25	18:00:00	64.11
01-Jul-25	19:00:00	64.11
01-Jul-25	20:00:00	64.11
01-Jul-25	21:00:00	59.2
01-Jul-25	22:00:00	59.2
01-Jul-25	23:00:00	67.73
01-Jul-25	00:00:00	67.73
01-Jul-25	01:00:00	53.18
01-Jul-25	02:00:00	53.18
01-Jul-25	03:00:00	60.58
01-Jul-25	04:00:00	60.58
01-Jul-25	05:00:00	64.81
01-Jul-25	06:00:00	64.81
02-Jul-25	07:00:00	65.54
02-Jul-25	08:00:00	65.54
02-Jul-25	09:00:00	64.81
02-Jul-25	10:00:00	64.81
02-Jul-25	11:00:00	65.54
02-Jul-25	12:00:00	65.54
02-Jul-25	13:00:00	68.93
02-Jul-25	14:00:00	68.93
02-Jul-25	15:00:00	59.06
02-Jul-25	16:00:00	59.06
02-Jul-25	17:00:00	49.83
02-Jul-25	18:00:00	49.83
02-Jul-25	19:00:00	39.03
02-Jul-25	20:00:00	39.03
02-Jul-25	21:00:00	59.47

[tharunkumarRTK · Accepted solution]

@Mramono 

I would suggest you to

1. Choose appropriate data types before loading the Date, Time and Value columns into power bi.

2. Create a Date table with all the necessary columns that you would need for your reporting purpose

3. Create a one to many relationship between Date table and your fact table where you have the actual data.

4. Create a trend line chart with "Date" and "Time" column on X Axis and value on the Y axis fields.

Note:

If you also want to create a Time table, then you need to aggregate your data at hour level, or 30, 20 or 10 mins window buckets. In my opinion unless you want to perform some comlex time based calculations, Time table is not required.

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[Mramono]

@tharunkumarRTK thank you for the solution, i finally could bring my data into graphs by using both the date and time on the x-axis as you suggested. Unfortunately I still need to do complex time based calculations hence i think i still need to use timetable.

Although is now working, using calendar table for dates and time table for time, i have a challege to shift both my calenda date and time table. My day starts at 6am in the morning and end at 5:59am the following day. E.g for the Date 17th August, my day starts at 6:00am 17th August and ends at 05:59am 18th August and so forth. 

Is it possible to set up the calender table and time table to reflect this shifted time? How can i go about it. Currently my hourly graphs starts from 00:00 to 23:00 each day. I want my hourly graphs to start from 06:00 to 05:00.

[Royel]

Hi @Mramono  You can simply add the date and time columns together, i am assuming column Date is a date data type and Time is a time data type. 

DateTime = [Production Date] + [Time]

If this method not workes, try this solution

DateTime = [Production Date] & " " & TIME(HOUR([Time]), MINUTE([Time]), SECOND([Time]))

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!