Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change data type in header

Hello All I am looking to do a report for sales by month. When the data is loaded into Power BI, power BI is picking up data as 'text' instead of 'date' (month) . Is there a way to change it so when...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    The data type is determined by the data in the column, not by the header.  In your image the numbers are being shown as any type abc 123 

    If you want to do reporting by month then you need to rearrange the data so that you have a column for date and a column for values like this

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

The data type is determined by the data in the column, not by the header.  In your image the numbers are being shown as any type abc 123 

If you want to do reporting by month then you need to rearrange the data so that you have a column for date and a column for values like this

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.