Forum Discussion
'Reset' Sort in Table View
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
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.
5 Replies
pls try to use year & month , e.g. 2023Jan, 2023Feb, then sort the new column by Month No.
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.
