Forum Discussion
Power BI -> Pivot Table. Date column returning as text.
Hi v-hashadapu thankyou kindly for your response.
That is unfortunate to hear but as suspected.
Unfortunately I do need this to work with just PivotTables as the current business analysts are used to this solution, and a PowerQuery/CUBE/ copying pivot outputs would create unnecessary friction.
Hoping there is a native solution to this - and if not currently I think should be implemented as a solution.
Thanks,
Zack
Community SupportHi ZWJ_Create,
You could definitely raise this in the Microsoft Fabric Ideas. I think it’s a reasonable enhancement request because the current behavior breaks a lot of normal Excel expectations around dates and numeric fields. Since Microsoft does actively review customer feedback there, with enough upvotes these ideas may be implemented as features.
Thanks - I think I will submit one there for completness.
Best,
Zack- v-hashadapu
Hi ZWJ_Create , Thanks for the update. please do share the link once you do, so the others who also require the same may upvote it.