Sorting visual by date not by Value

[ankurbajaj07]

HI,

I am having a date table having relationship with all other tables. Date table is sorted on year-month column (As whole number).

When i use this date table (month year column) alone in visual table it shows correct sorting by year month  but when i use it as a drag & drop in some other visual like matrix where I have other data values, sorting option on visual (clicking 3 dots on visual) gives sorting for values only and not for date.

Because of this my values is sorted as Feb Mar & Jan , not Jan Feb Mar or Mar Feb Jan.

I am not understanding whats the issue .

This is correct sorting output

Correct

Not correct sorting - ascending / decending works for values not fo rdate header

Dat atble already sorted by year month with whole number

Please help.

Thanks in advance.

[danextian]

Hi @ankurbajaj07 ,

Seems to be a bug. Try removing the count  from the value tile and add it back again.

[amitchandak]

@ankurbajaj07 , Click on Column Month year and mark Month year sort column as the sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[ankurbajaj07]

I have already mentioned that in my post. Its already sorted on year month sort column.