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
Anonymous
https://ideas.powerbi.com/ideas/idea/?ideaid=e9b77e43-84bc-4440-9e3f-0725dcf60cd3
Go Vote 🙂
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
6 Replies
- SpartaBI
Community Champion
Anonymous
https://ideas.powerbi.com/ideas/idea/?ideaid=e9b77e43-84bc-4440-9e3f-0725dcf60cd3
Go Vote 🙂
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI 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 👌😀
- SpartaBI
😀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.
