Reply
Ivashamagnus
Frequent Visitor
Partially syndicated - Outbound

Correct recording of time periods. Empty cells.

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?

123123.jpg545345345.jpg

1 REPLY 1
lbendlin
Super User
Super User

Syndicated - Outbound
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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)