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.
I have the table where my data column looks like this but my visual is showing data ordered by months (January comes before December) I would like the first data point to be the oldest one. So x-axis should start with July 2022, and August 2022........March 2023 and April 2023. Can this be accoplished?
Solved! Go to Solution.
Reformating the date to MMMM YYYYY and changing the axis type to "Categorical" resolved it for me.
Reformating the date to MMMM YYYYY and changing the axis type to "Categorical" resolved it for me.
@stribor45 , better use year of axis and expand and switch off concatenate label -off
Or sort your month on this column
month = if(month([Date]) <7, month([Date])+6 , month([Date])-6)
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
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 |