- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 display the months in correct order and year but It is puzzled and I am not able to see the correct variation.
So this is the representation in front of me. How Can I sort it.
Thank you
Regards,
Diksha
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Can you please confirm if the data type of your date column is date or something else ?
Regards,
Jaideep Nema
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous a quick check , have you already tried the sort option on the visual ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Yes, I already tried it but It is not working.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

So, in the table of PBI, the "Date" column (you got from excel) has been marked as Data Type "Date"?
If so, you may have to create another table for sort... as other replies introduced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
I suggest having one more column in your dim-date table for the purpose of sorting.
For instance, you can create endofmonth column by using the date column and the EOMONTH function.
Then you can sort the month-year column by the newly created column.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for replying Jihwan.
I tried it but what to do in ENDOFMONTH Function?
I'm not getting option to write the column name in it?
Could you explain in detail. Header name for date column in format Jan-16 is No. of working days.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
Thank you for your feedback.
If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a more relevant solution.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes Sure..I've made a sample file your reference and the link is attached below.
https://drive.google.com/file/d/1kZyc4NsV0fmrLhTEt_c06MQFdQx53y5r/view?usp=sharing
Regards,
Diksha Gupta
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
after downloading the PBI file you shared, I didn't find the column is "Date".
Here is what after changing the column type:
Is this what you are expecting?
H
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @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
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for helping but It is not working.
Best Regards,
Diksha Gupta

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 08-21-2024 02:10 AM | ||
08-02-2023 01:36 AM | |||
05-23-2024 10:14 AM | |||
01-01-2024 01:24 AM | |||
08-12-2023 02:23 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |