Need help on sorting with order

[Anonymous]

Hello,

I'm having trouble on the sorting.

I have two table, one table is called 'Date_Match', built up date and order like 'JAN' = 1,'FEB'=2, then set the column sort by this order, and in relationship, I connected these two table with Month as primary key, the order display looks good before I apply another table slicer in table 'Detail', please see below, the slicer only contains "Y" or blank and when I apply this filter, the month order would changed, how I can solve this problem to display month still from Jan - Mar, thanks all!

[amitchandak · Accepted solution]

@Anonymous , Make sure month has sort column and it marked as sort column. Second Sort the visual on month using three dots 

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