Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
I highlighted the arrows that you should click
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |