Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
avater4566
Frequent Visitor

Show more timestamps on continuous x-axis (lower the interval)

Hi, 

 

I was wondering if it is possible to show more timestamps on the x-axis of my graph. Currently every hour is visible but ideally every 15 minutes would be shown.

 

How do I solve this without changing my x-axis to categorical? Because with that, not all times are shown and there is for example a jump from 16h00 to 16h45.

 

avater4566_0-1700226263219.png

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @avater4566 

Only the categorical axis shows every point of the values.
To avoid gaps because of the lack of transactions in some timeslots you need to use a dim_time table and the option "show items with no data".
My timetable is with 1minute timeslots, so it looks that way:

Ritaf1983_0-1700287797915.png

In your case, you need to create a table with 15-minute time slots

Ritaf1983_1-1700287906955.png

 

To create a dim time table please refer to the linked tutorial:

https://www.youtube.com/watch?v=-q7v56p192M&t=8s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @avater4566 

Only the categorical axis shows every point of the values.
To avoid gaps because of the lack of transactions in some timeslots you need to use a dim_time table and the option "show items with no data".
My timetable is with 1minute timeslots, so it looks that way:

Ritaf1983_0-1700287797915.png

In your case, you need to create a table with 15-minute time slots

Ritaf1983_1-1700287906955.png

 

To create a dim time table please refer to the linked tutorial:

https://www.youtube.com/watch?v=-q7v56p192M&t=8s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.