cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.


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

Proud to be a Datanaut!


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.


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

Proud to be a Datanaut!


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!


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