Forum Discussion
Months not in order
I have files from Salesforce, one being Action where there is a Completed Date that the Action has been done, as well as the same in a file Activity with a Completed Date column as well. When i Chart either action or activity the months are not in order, nor are the quarters. What can I do to fix this issue? File from SalesforceCharts
I discovered that if you sort on the visual it will categorize correctly. Redoing the visual in the most current version did not fix the issue. But this sorting method seems to be providing the correct output so I will run with that.
8 Replies
v-jiascu-msftMicrosoft Employee
Hi lrockwell,
1. I would suggest you upgrade the Power BI Desktop to the newest version. In my test, all the orders are good;
2. Maybe you could add a new column "MonthDay" with this formula. Then click "Completed Date", select "sort by column" "MonthDay".
MonthDay = format([Date],"mmdd")
3. Create a date table, then create relationships with the current tables.
Calendar = ADDCOLUMNS ( CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ), "Month", FORMAT ( [Date], "MMMM" ), "MonthNum", MONTH ( [Date] ), "Quarter", FORMAT ( [Date], "q" ) )Best Regards!
Dale
Hi, Recently had same type of issue. I had created all types of columns, all correct formatting, that 'logically' should have worked to sort it out.
I didn't want to add a date table to my report initially so I was trying to 'fix' the issue. Finally I gave up, created a seperate datetale, linked to my data on date, and viola!
Try creating a date table as also suggested by v-jiascu-msft.
- v-jiascu-msft
Hi lrockwell,
Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.
Best Regards!
DaleI have the latest version of Power BI installed.
This is the error i am getting when i create a new column and sort the Completed Date on that
