Forum Discussion

travbum's avatar
travbum
Advocate I
9 years ago
Solved

Visualization can't remove Time from Date

  I've split a column in to two parts, "CreatedDate" and "CreatedDate_TimeOnly". When I go to chart the "CreatedDate" it's still giving me times for the data. How do I remove this?     
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

    This looks like formatting only. Go to the data view and change the format of the date column to exclude the time format

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi travbum,

     

    You should be able to change the data type of "CreatedDate" column to Date type and format it under Modeling tab by first clicking the column within your fields.:smileyhappy:

     

     

    Regards

MattAllington's avatar
MattAllington
Community Champion
9 years ago

This looks like formatting only. Go to the data view and change the format of the date column to exclude the time format

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Changing the data type format from 'DateTime' to 'Date' under the data model view worked.
    Thank you!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I've tried everything, changing the type format in formatting, changing the data type and I don't want to change the x-axis to Category. How can I solve this?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        If changing the data type/format doesn't resolve the issue - change the x-axis under visual settings from 'Continuous' to 'Categorical'