'Reset' Sort in Table View

[ME_1976]

Hi, hope someone can help. 

I set out the data (see screen grab 1) and meant to select Month No to sort the data, however, I selected Month Name in error. I've tired to reset the data, deleted/re uploaded it, change sort column and still receive the message in screen grab 2. The document is saved, so unable to just close the app and start from earlier. If that makes sense. I'm sure its something simple that I'm missing out on doing (I'm new to PowerBi). Any assistance would be most apprecaited. 

Screen Grab 1

Screen Grab 1

Screen Grab 2

Screen Grab 2

[Anonymous · Accepted solution]

MONTH(<datetime>) use this to make month no from date column

[Anonymous · Accepted solution]

your month no is exceeding over 12

[Anonymous · Accepted solution]

Hi,

Thanks for the solution @Anonymous  and @ryan_mayu  provided, and i want to offer some more information for user to refer to.

hello @ME_1976 , based on your description, you can refer to the following solution.

Sample data 

1.Create a table, then in new table, select the month column and select sort by month_no column

Table 2 = SUMMARIZE('Table',[Month],"Months_No",SUM('Table'[Month No]))

2.Crete a relationship between the tables

Then in the visual you can use the monthname column of the new table.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

pls try to use year & month , e.g. 2023Jan, 2023Feb, then sort the new column by Month No.

[Anonymous]

your month no column should only have 1 to 12 number the screen grab 2 says the error simple sort by column assigns month 1 to 12 to each month that is 12 month name in the year hence in month no there should not be more than 12  your error will get solve easily

[Anonymous · Accepted solution]

MONTH(<datetime>) use this to make month no from date column

[Anonymous · Accepted solution]

your month no is exceeding over 12