Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date format on chart

Hello

 

I’ve got a pivot table from a power pivot model. The model’s data is sourced for an SQL server 2012 database. I’ve created a simple chart based on the pivot table.

 

I can format the date field on the Pivot table, but the formatting on the chart doesn’t change. I’ve tried every which way to format the chart, but nothing seems to work. It looks as if the chart sees the date value as a string?

 

 

Any suggestions

Thanks in advance.

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Try this

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Anonymous ,

     

    Apologies if this sounds a bit obvious, but have you tried changing the data to DATE type at source?

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for the reply. It is a date at source and in the power pivot model.

  • KNP's avatar
    KNP
    Super User
    4 years ago

    Is there any way you can provide a sample file without sensitive data?

    It'll be much easier to help with a sample to work with.

     

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    Try this

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.