Forum Discussion
Month not getting sorted Correctly
Hi abhishek_300,
For Direct Query of tabular, It's so strange cause if you have Dates(Date column, Month no column, Month Name column,...) table and Fact table in your tabular with relationship of Date column, it will be sorted automatically when you use Month Name column in chart.
Could you please check your Tabular Model, properties of Month Name column, choose Sort By Column property and assign the Order Column for it?
https://msdn.microsoft.com/en-us/library/hh479566.aspx (Sort By Column)
Refer topic: https://www.simple-talk.com/sql/bi/creating-a-date-dimension-in-a-tabular-model/
This filed is disabled has I have connected to the tabular model using direct query.
Hi abhishek_300,
For Direct Query of tabular, It's so strange cause if you have Dates(Date column, Month no column, Month Name column,...) table and Fact table in your tabular with relationship of Date column, it will be sorted automatically when you use Month Name column in chart.
Could you please check your Tabular Model, properties of Month Name column, choose Sort By Column property and assign the Order Column for it?
https://msdn.microsoft.com/en-us/library/hh479566.aspx (Sort By Column)
Refer topic: https://www.simple-talk.com/sql/bi/creating-a-date-dimension-in-a-tabular-model/
Thanks tringuyenminh92,I change the sorting order in the properties of Tabular Model and now it is getting sorted correctly.
Thanks for your help