cancel
Showing results for 
Search instead for 
Did you mean: 
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
edhans
Super User III
Super User III

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 IV
Super User IV

Choose a format without time. the datatype is correct.

Instead of  general format choose one without time.

 

Data Format.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

edhans
Super User III
Super User III

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors