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,
I'm new to Power BI desktop. I want to plot a very simple chart showing the population (in columns) and proportion (line) from 2016 to 2061 (data are by 5-year interval).
When I set the X axis as continuous, labels are from 2020 to 2060. I tried to set the minimum to 2016 and maximum to 2061, but it doesn't change anything. See screenshot below.
When I set the axis as categorial, labels are fine, but it orders data from the highest to the lowest.
How can I have a chart ordered properly by year and showing the good labels, either 2016-2021,...,2061. I see other posts on this, but no solution works for me.
Solved! Go to Solution.
@Demographer , Axis type categorical and sort ascending from three dots (...)
@Demographer , Axis type categorical and sort ascending from three dots (...)
Proud to be a Super User!
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 |