Forum Discussion

Amomin1988's avatar
Amomin1988
Frequent Visitor
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    6 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

  • Anonymous's avatar
    Anonymous
    Not 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