cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CoreyPawlak Frequent Visitor
Frequent Visitor

Re-ordering the x-axis values

Hi, I  am creating Power BI reports and would like to re-order the presentation of the x-axis values in a couple of charts.

1) In a chart showing time-to-consume on the x-axis, I have the x-axis values as <5 min, 5-14 min, 15-60 min, >60 min.  I'd obviously like them ordered chronologically, but they're showing up in the following oder: <5 min, >60 min, 15-60 min, 5-14 min -- not exactly intuitive for the viewer!  How can re-arrange the order in which they're presented?

 

2) Similarly, I've a chart with x-axis values: Read, Watch, Try, and Prove.  Instead of being ordered by this logic, they're being ordered alphabetically as Prove, Read, Try, Watch.  How can I order the values in my desired order?

 

I'm relatively new to Power BI (and love it!), so please be detailed in (hopefully) presenting a solution.

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Re-ordering the x-axis values

You need to use "Sort By Column" in the Modeling tab in the Data Model. So, go to your Data Model, choose your column go to Modeling tab and choose "Sort By Column". In your case, it may make sense to create an Enter Data query and put in your x-axis values along with a "Sort By" column, so something like:

 

Category,Sort By

<5 min,1

5-15 min,2

15-60 min,3

>60 min,4

 

Sort your Category column by "Sort By", relate this table to your fact table. Use this Category field in your visual. That's the gist of it.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Re-ordering the x-axis values

You need to use "Sort By Column" in the Modeling tab in the Data Model. So, go to your Data Model, choose your column go to Modeling tab and choose "Sort By Column". In your case, it may make sense to create an Enter Data query and put in your x-axis values along with a "Sort By" column, so something like:

 

Category,Sort By

<5 min,1

5-15 min,2

15-60 min,3

>60 min,4

 

Sort your Category column by "Sort By", relate this table to your fact table. Use this Category field in your visual. That's the gist of it.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

CoreyPawlak Frequent Visitor
Frequent Visitor

Re: Re-ordering the x-axis values

It worked!!! Thank you so very much!

Super User
Super User

Re: Re-ordering the x-axis values

Cool, happy to help!


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

perpor Member
Member

Re: Re-ordering the x-axis values

Thanks !!!

Diego-mx Regular Visitor
Regular Visitor

Re: Re-ordering the x-axis values

I found this post to order values in the x-labels, which I also am looking for solutions.
In my case, however, I'd like the order to follow from another column -call it value- based on its average, and using the x-axis column as a grouping variable. 

I did see find value under Modeling > Sort by Column, but it didn't work to order because there are different values for each x-axis label.  

How do I go about to calculate the average and sort the x-axis column? 

Thank you. 

 

 

daviddvorak Frequent Visitor
Frequent Visitor

Re: Re-ordering the x-axis values

Good solution, what happens when the "Sort by column" feature is not clickable?

 

SortByDisabled.png

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 1,096 guests
Please welcome our newest community members: