Share via

Power Map date/ time

Anonymous
2016-05-06T14:14:21+00:00

Hello,

I am using the Power Map preview for Office 2013. I am unable to move my date data to the Time field in Power Map ( I get a "no" symbol when I try to drag and drop the field). This data is written as Apr 2013. I have it formatted as Date (I have tried a variety of format options with no success).  Can any one tell me how to make this work?

Thank you very much

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2016-05-06T23:11:10+00:00

Hi,

That is not the reason.  The date can have a leading 0.  The reason for it not working is that the dates are stored as text entries.  On running the Data > Text to columns command, the text dates convert to actual dates.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-08T00:31:13+00:00

    Good to know, thank you!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-06T22:13:59+00:00

    I figured it out. A date such as 01/15/2015 cannot have the leading zero. It has to be 1/15/2015. I changed this using Data>Text to Columns>Next>Next>Date: DMY

    Was this answer helpful?

    0 comments