Sorting Problem (Bar Chart)

[markmm]

Hi,

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?

thanks for answer

[#2]

Try sorting by numeric value.

[stephencredmond · Accepted solution]

Hi Mark,

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:

   max(Num.Date)

Regards,

Stephen

[stephencredmond]

Hi Mark,

You should mark the response as "Correct Answer".

Thanks,

Stephen