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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors