Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!
Solved! Go to 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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingsince 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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting