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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
BuistJF
Helper I
Helper I

Date shown on axis though field is a time

I have some dax that produces a calculated column where time is rounded to the nearest 30 minutes - 

Requested Time = MROUND(DSET_TABLE[Requested_Time],"0:30"). The Requested_Time column only contains 'Time' and has a data type of 'Time'. When I add this to a visual it shows the time but preceded with a date which is always the 30th December. This date doesnt exist in the data set and the calculated column has a 'data type' of time with a 'format' of short time (13:30). I have played around with the x-axis including changing from continous to categorigcal which does solve the problem though you then cant view the data in a single chart like below (scroll bar added).
BuistJF_0-1686051178092.png

Any ideas on how to solve this issue?

1 REPLY 1
lbendlin
Super User
Super User

sounds more like a datetime data type. Dec 30 1899 is the hard coded start date, equivalent of 0  (based on UTC)

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.