Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Eternally333
Regular Visitor

How to show each continuous consecutive year on PBI X axis

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

1 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!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.