05-24-2018 11:43 PM
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 would love to have a common European format: 14-03-2001 as dateformat, but this is not supported....
When I go to Excel with Analyze in Excel I get this:
So a you can see I lack al the possibilities that a datecolumn has in Excel Pivots. A normal pivot gives this:
This is caused by that it is not a datefield but a normal text.
Can this problem be solved by something? Like choosing an other dateformat or something?
05-25-2018 02:04 AM
I thought I was completely insane when you posted your printscreen.... But I've looked again and can't find that options in my Power BI Desktop (most recent edition (may 2018) installed). See:
My regional settings are: Dutch (Netherlands), but I've also tried other European countries, like French (I assume you're using that when I see you're printscreen). But no effect....
05-25-2018 02:10 AM
05-27-2018 11:53 PM
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:
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?
06-05-2018 11:36 PM
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???