Forum Discussion
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.
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.
It worked!!! Thank you so very much!
Cool, happy to help!
Thanks !!!
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.
Good solution, what happens when the "Sort by column" feature is not clickable?
