How to show each continuous consecutive year on PBI X axis

[Eternally333]

Hi

How can I get every single year to show on X axis? The date column in the data in a continuous list of just years (no dates/months) i.e. 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967. with no gaps. All the other column data have no gaps so data is complete. However the line chart x axis visual only shows

the first year 1960,

2-year intervals so 1960, 1962, 1964, 1966

and it doesn't show the last year 1967

The x axis is on 'Continuous'. If changed to 'Categorical' it does show every single year but in a random order that doesn't make sense. How to show each year, the right order please? Thanks

[amitchandak]

@Eternally333 , Make sure Axis Type Categorical and the sort is on Year/Axis. Sort may be on measure

[Eternally333 · Accepted solution]

Couldn't find this AXIS menu within Visualisations pane - now saw it now top right ... of chart. 

Yes axis was indeed on one of the MEASUREs. 

Sorting then put YEAR Y axis in wrong order (latest YEAR first) so just also needed to SORT ASCENDING and it works. Thanks!