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...
Is your question really "how do i make sure my axis displays in month order rather than alphabetical?"?
If so, you can use the 'Sort by column' functionality. You can search the forum for similar or add a column with 1-12 for the month (possibly in a dimension table)
Yes that is the idea behind it but I don't understand how Sort by column will work if all the columns involved are text. I will search the forum for this and see if I can figure something out. How do I add a column in a measure? I could not figure that out, but I did try to create a measure that would do that with no luck. I will continue to search the forum and the web but I have not had much luck so far.
Thanks
