Forum Discussion
Sort by another column no longer work
Your Seq column has repeating values, so DAX doesnt know how to sort that data when there are two fields with, say, 1. Need to figure out some other logic so that there are not repeating figures. I dont know enough about your data to suggest anything though, but couldnt you just sort by your EnrMonth column?
Thanks for the suggestion. It worked well before which tells me it is able to reconize two rows with the same data.
No, sort by enrMonth is not goingto work here becuase it's 1 to 2 match (One month name will get two EnrMonth) I will get the same error msg which now makes perfect sense.
Anonymous wrote:Your Seq column has repeating values, so DAX doesnt know how to sort that data when there are two fields with, say, 1. Need to figure out some other logic so that there are not repeating figures. I dont know enough about your data to suggest anything though, but couldnt you just sort by your EnrMonth column?
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
