'Reset' Sort in Table View

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

your month no is exceeding over 12

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.