Correct recording of time periods. Empty cells.

[Ivashamagnus]

Hello dear Power Bi masters!

I collect data from the beginning of my sleep and the end of my sleep to display it on a graph.

I guess I'm recording this data incorrectly.

Question: how should I correctly record data in my case?

I will visualize it in Deneb in Power Bi desktop on the advice of Super User lbendlin.

My goal is to get a visualization of my sleep segments on a graph. I will show an example of visualization in the picture.

note: I heard that you can't use tables with empty cells in power bi. This is true? The fact is that one day sometimes has 2 or 3 sleep areas, which means 2 or 3 rows in a table with one day. In this case, some data in the columns should have no values to avoid doubling or tripling the values on the same day in the graph. How can I enter data correctly for deneb power bi?

[lbendlin]

My goal is to get a visualization of my sleep segments on a graph

The fact is that one day sometimes has 2 or 3 sleep areas, which means 2 or 3 rows in a table with one day. In this case, some data in the columns should have no values to avoid doubling or tripling the values on the same day in the graph

It is up to you to decide how you want this chart to look like. It's not really a problem to plot multiple sleep periods for a day.  You'll have to decide what to do with overnight sleep - most likely cut it into two parts at midnight as they occur on different days.