Forum Discussion
Solved
How to Sort Days and Month in Chronological Order - Power Bi
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 ...
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.
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.
sureshsontiHelper II
I highlighted the arrows that you should click