Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |