X axis labels for combo stacked columns+line chart

[Demographer]

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.

[amitchandak · Accepted solution]

@Demographer , Axis type categorical and sort ascending from three dots (...)

[vanessafvg]

its not showing 2061 because its ony showing it in 5 year intervals if you want to show all you need to change the way you are doing the intervals. If you provide some dummy data in text format that would be useful to show you.