Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
8 years ago

Analyze in Excel causes problems with dates

Hi all,   I'm facing some issues with date fields while Analyzing in Excel a Power BI report with an integrated model. I set the dateformat of a datetime field from SQL to this:     I woul...
Need Help
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

MiKeZZa

 

That's really strange !

 

I'm using French version from april 2018, but even when I had the may version it was fine.

 

I don't know what's the matter, perhaps english version only have the mm/dd/yyyy version and not the dd/mm

 

Anonymous any info on that ? 

MiKeZZa's avatar
MiKeZZa
Post Patron
8 years ago

Installing a Dutch version of Power BI Desktop did give me the options like you see! So in my visual it's better now; I have these dates:

 

01-01-11
04-01-11
05-01-11
06-01-11
07-01-11
10-01-11
11-01-11
14-01-11
18-01-11
19-01-11
24-01-11
01-02-11

 

So that's what I was looking for! Thank you for that.

 

But Analyze in Excel still behaves like it's a string in stead of a date.

 

Anyone some ideas about that?

  • MiKeZZa's avatar
    MiKeZZa
    Post Patron
    8 years ago

    I have a problem with the use of dates in analyzing in Excel. When I analyze a datamodel that is made in Power BI I don't receive the options like you get normally when you analyze a regular Pivot, like these:

     

     

    But I get in Excel these options (the regular 'text' options):

     

     

    Has anyone the solution for this???