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/
Hi abhishek_300,
You need one OrderColumn in your tabular model with value = Year*100 + MonthNo (201607, 201608, ..) so you could sort column Month Year by that order column in Power BI.
Are you using Import mode or direct query? Cause using import mode, you could create order column by adding Condition Column in Power BI, but with Direct Query, you need create order column in server side of tabular model
hI,
Thanks for your reply.I am using direct query and I am creating dataset directly from the Power BI Pro. I am not using Power BI desktop.
So do I need to create an Order column on tabular model using below query
OrderColumn = Year*100+Month_Number.
So that will be 2017*100+1= 201701.
So does that mean I will have to show to the users 201701 and I cannot use the column with the value like January-2017 in the visual.
Hi abhishek_300,
You show January-2017 column but sort by order column, you need to do it in Power BI Desktop and publish pbix file.
This filed is disabled has I have connected to the tabular model using direct query.
