Forum Discussion
Analyze in Excel - Date field issue
When using 'Analyze in Excel' Date fields from my model show up in excel as text which really limits the usage of the Analyze in Excel functionality. Has anyone else encountered this and come up with...
To anyone having this issue, can you test this for me? I have no problem with this working, but this comment made me think:
My date fields are always formatted as Short Date - so mm/dd/yyyy for US. I am wondering if that long normal format is confusing Excel and it thinks it is text. If yours is formatted like that, can you change it to the Short Date format, republish, then see if analyze in Excel works correctly? Here I am using the date field in the Timeline slicer just fine, and showing the date format in the 2nd matrix in columns.