Forum Discussion
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...
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?
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???