I have added a test application in which you see two charts (bar/straight table) sorted by a numeric date for that the weeks are in ascending order. the sorting works in in table, but in the bar chart (sort by expression) it doesn't work. I don't know why?
The problem here is that there is not just one Num.Date value for each week so the Sort expression will return multiple values and that is, essentially, null.
You need to return just one of the values so use Max or Min:
The problem here is that there is not just one Num.Date value for each week so the Sort expression will return multiple values and that is, essentially, null.
You need to return just one of the values so use Max or Min:
