Forum Discussion
Default date added to visual
Hi All,
I have created a stacked column chart as a visual with time as the Axis. For some instances (when there's only 1 date and time), the visual will show the default date in the axis instead of the dates from the data source.
When I open up Query Editor to make sure that I've set the column data type correctly, I see that it is. I have a time column set as Time only. The default date does not show up when I use the drop down to double check.
I close and apply, refresh the page. The date remains in the visual. When I go to the data view and use the drop down, I see the default date.
Any suggestions on what I can do to fix this? My time format is set to h:mm tt if that makes a difference. I appreciate any guidance! Thank you
- Anonymous6 years ago
HI Amomin1988 ,
Power bi will recognize date/time fields as DateTime format and add correspond time/date part if your records are purely date or time. You can modify your field type to date or time to hide auto-fill default values.
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI Amomin1988 ,
Power bi will recognize date/time fields as DateTime format and add correspond time/date part if your records are purely date or time. You can modify your field type to date or time to hide auto-fill default values.
Regards,
Xiaoxin Sheng