Forum Discussion
Using date format while using a data set in Excel from Power BI
Good evening, I am having problem while using a data set from Power Bi in Excel. I have mainly 2 problems while creating pivot tables: 1- Numbers are not recognize as number but as text whic...
Hi josujimenez1994
You will need to transform your data first. To do that follow these steps:
1. Go to "Transform Data"
2. Next go to "Transform"
3. Select the required column e.g. Date and change the Data Type to Date or Date/Time as needed
4. Do the same for text column not recognised as number
5. Close and Apply
Sample screenshot for reference:
If I answered your question then pls mark my post as "Accept it as the solution" and a kudo would be appreciated.