Forum Discussion
Sort by another column no longer work
Do you mean this error happens when you sort by [sep] in a visual like below?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The error occours in the data modeling tab sort by Column tab. I need to create a bar chart where monthName is sorted in order therefore I had to do it in the data modling tab (where error occurs).
Its somehow related to how data was loaded. See my data below. Previously, I added a filtered rows in QueryEditor to limit the data to the latest ReleaseDate. Somehow it did not work this time, even I can not see any 2019Qtr1 rows but PowerBI still think its there. I fixed it by delete and reload the data.
Thanks again for all the help.
| Release Date | YYYYMM | MonthName | Seq |
| 2019Qtr1 | 201810 | Oct | 1 |
| 2019Qtr1 | 201811 | Nov | 2 |
| 2019Qtr1 | 201812 | Dec | 3 |
| 2019Qtr1 | 201901 | Jan | 4 |
| 2019Qtr1 | 201902 | Feb | 5 |
| 2019Qtr1 | 201903 | Mar | 6 |
| 2019Qtr2 | 201901 | Jan | 1 |
| 2019Qtr2 | 201902 | Feb | 2 |
| 2019Qtr2 | 201903 | Mar | 3 |
| 2019Qtr2 | 201904 | Apr | 4 |
| 2019Qtr2 | 201905 | May | 5 |
| 2019Qtr2 | 201906 | Jun | 6 |