Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |