Forum Discussion
Convert Month text to Date
I have a line chart that goes by months. The problem is the months are full month text January, February, ect. The data is linked to an Excel file in my OneDrive so there are no tables in my Power BI...
Hi HotChilli,
In fact, if you refer to these steps to get data from files to power bi desktop, the edit features will not be limited to use.
After these steps, you can refer to other community user sharing to create calculated expressions about data type conversions.
In addition, if you did not want to change these field types, you can also consider creating a custom sort table for the specific fields sorting.
For the fields text formatting, you can also take a look at the below document about power bi custom string of field values:
Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng