Using Power BI data set as source for Excel pivot table

[Anonymous]

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

[Anais_M]

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.

[josujimenez1994]

Hi I have the same problem. How did you solve it? thanks in advanced !!!! @Anonymous 

[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

[Anonymous]

@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 😉

[SpartaBI · Accepted solution]

@Anonymous 
https://ideas.powerbi.com/ideas/idea/?ideaid=e9b77e43-84bc-4440-9e3f-0725dcf60cd3
Go Vote 🙂

      

Showcase Report – Contoso By SpartaBI