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...
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.

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