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
udian
Helper III
Helper III

Date field displaying time

Hi,

 

i am connecting with live connetion to my tabular model.

 

When i drag my Month_Date column from my time dimension to Axis in a line chart and choose to display it as categorial in the design tab (diplay all the different months on the axis), the values are displayed witn time 12:00:00.000 and not only the date.

The original value is only date without time.

 

Why is the time added and how can i remove it without switching the display mode to continues?

 

*The field definitions in the tabular model are Data Type = Date, Data Format = General

 

Thanks!

1 ACCEPTED SOLUTION

This seems to be a bug. I am seeing the same thing connecting to the AdventureWorks cube. It is a date field, but PBI shows date and time, always 12:00:00am



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Set particular format and check at tabular model side only.

I think you model is not processed or properly deployed.

Thanks
Pravin
amitchandak
Super User
Super User

Choose a format without time. the datatype is correct.

Instead of  general format choose one without time.

 

Data Format.png

since i am connected with live conection i have no control of the date formating via PBI.

 

I will try to set a fromat different than General on the tabular model although when using excel to connect to the cuve everything works fine.

This seems to be a bug. I am seeing the same thing connecting to the AdventureWorks cube. It is a date field, but PBI shows date and time, always 12:00:00am



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors