Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 ReportingUser | Count |
---|---|
85 | |
77 | |
68 | |
49 | |
41 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |