Showing results for 
Search instead for 
Did you mean: 
nsadams87xx Regular Visitor
Regular Visitor

Sort by Column using reference key does not work

Hey everyone,


I'm trying to show a graph of valuations over time and these timeframes are arbitrary because my different units (automobiles) are not all the same model year.  I have a very simple time dimension which gives each one of my time references a key and when I sort by this key, my axis isn't showing the way I want it to.  I want it to be in this order: New, 2 Years, Half Life, Low Point, Current.


The only way I can get it to sort correctly is if I include both the time key and the Key Name in my axis together and I don't want the time key number displaying on the axis.  Any thoughts?



My "fact" sorted by the time key.






My "time dimension".

Time Reference.JPG



Incorrect order.




Correct axis but having to use the time key on the axis.  This has also been drilled down to the lowest hierarcy.

Correct with key.JPG



Super User
Super User

Re: Sort by Column using reference key does not work

Any sort you apply to the data screen is purely visual.  What you want to do instead is select the field that you are using on your Axis, and go into the Modelling area of the Ribbon.  In there is a "Sort By Column" selection where you can choose your Time Key field.


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

Proud to be a Datanaut!