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,
My visuals are getting confused by the months. January is Jan 2019, but is put at the left of the x-axis, instead of the right.
The data has the year in it - what is going wrong?
Thanks for the help.
James
Hi @Anonymous
You need to have another column that is in the right order and use it with the feature "Sort by column" in the modelling pane.
See this for more details. Since you have months spanning more than one year it'd be good to use a typical YearMonth column that you probably have in your Date table already. If not you can easily create it with something like:
YearMonth = Year('Date'[Date]) *100 + MONTH('Date'[Date]).
Then select the "Month" column you're using in your axis, press 'Sort by Column' and choose YearMonth
Once you've set the Month column to order by YearMonth, go to your visual, click on the ellipsis on the top right corner and choose Sort by "Month" and then Sort ascending.
That should be it.
Cheers
Thanks, managed to get there in the end!
I created a new column with the formula:
Which gave me just the month and year from the Entry Date column and then i formatted that as a date and it worked.
Thanks again for the help - got me on the right track!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |