Forum Discussion
Arrange date in correct order
Hi everyone, I plotted a graph but the date structure is not arranged graphically. I got this column of dates from my excel file and It is in format Jan-16 which means January, 2016. I want to di...
Hi Anonymous ,
Please create a custom column in power query:
= Table.AddColumn(#"Changed Type", "Datefororder", each Text.Insert([No. of Working Days],4,"20"))Then convert it to date in data view:
Then you can use sort by columns:
Please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Nathaniel_C
Community Champion
Community ChampionHi Anonymous You ,will have to use the Sort by Column in the Data view.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Thank you for helping but It is not working.
Best Regards,
Diksha Gupta