Forum Discussion
Analyze in Excel - Date field issue
I just want to resurrect this - we just ran into this issue today: Analyze in Excel doesn't treat date fields as dates, and thus my boss can't group things as he's accustomed.
I'm having the same issue. Very limiting
Hello everyone.
I'm coming from https://community.powerbi.com/t5/Service/Analyse-in-Excel-and-Date-Format/m-p/1061012#M94618
Is there any way to force columns to date format ?
I have many dates formatted as date in powerbi that powerpivot with analyse in excel reads as text and I want to filter them using power pivot date filters.
One workaround could we to load the data to power query instead of connection to the pbiazure and changing to date there. But I don't think this is possible, right?
I have created a idea for this. Vote!
