Forum Discussion
Ritesh_Air
Post Patron
Post PatronMonth Order Wrong
Hello, I put my post in other thread but it already had a solution so putting it here. In my visual, my month name is not sorting it correctly in my report. I have searched everywhere but...
You need to set the sort order of the month name short in your date table based on the month number. Take a look at this video that shows how.
https://youtu.be/NlX7Cp2P0d4?t=57
jdbuchanan71
Super User
Super UserThat is very strange. In your new report, the one using the shared data set, if you just put a table on a page and add the 'Month Of Year Short Desc' field to it, do the still come out in the wrong order? Just testing if it is something odd with the graph or the model behavior.
Ritesh_AirPost Patron
Post PatronAhhhhhh....I found what the issue was. It was not in the PBIX but with the onedrive. It was not refreshing the service so I was assuming I had the latest file but it was not. Thanks for your input.