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.

July Newsletter

Fabric Community Update - July 2024

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