How to Sort Days and Month in Chronological Order - Power Bi

[wesleyhucker]

Hi Guys,

I'm fairly new to Power BI and I'm tryng to create a small dashboard for a client. the problem is when using my data on a line graph, if selected 1 month, the dates are in chronological order, however, if I do beggining of the year to date the months show un sorted. see picture below.

[Anonymous · Accepted solution]

Create a new column using this DAX formula :

YearMonthInt = <tablename>[Date].[Year]*100 +  <tablename>[Date].[MonthNo] 

Then, select the Date column > In the Modelling tab, select 'Sort By Column' option and sort the Date column by the new Column u created.

[sureshsonti]

I highlighted the arrows that you should click