Forum Discussion
Using Power BI data set as source for Excel pivot table
Hi,
I have a problem when using Power BI data set as source for Excel pivot table.
When adding date in the pivot table, dates are formated as text (e.g. "02/01/2019"), but in Power BI it is correctly in date format. The makes me unable to sort by date and group by month etc.
I haven't found a way to change the dateformat in my pivot table.
/Bo
6 Replies
SpartaBI , Thanks for the link.
I voted 👍
It didn't solve my problem, but it saved me a lot of time trying to fix it though 👌😀
😀That is priceless 😉
Hi I have the same problem. How did you solve it? thanks in advanced !!!! Anonymous
Unfortunately, I didn't solve it. I still don't know any solut to this, but please feel free to vote on the suggestion below 🙂
https://ideas.powerbi.com/ideas/idea/?ideaid=e9b77e43-84bc-4440-9e3f-0725dcf60cd3
Hello,
Just create 3 new columns in your Date table : Year = YEAR(DimDate[Date]), Month et Day, in DAX, and you're good to go.
