cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

X axis labels for combo stacked columns+line chart

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.

Continuous.JPG

 

When I set the axis as categorial, labels are fine, but it orders data from the highest to the lowest.

Category.JPG

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

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

Axis_type.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Super User I
Super User I

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

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

Axis_type.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors