Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

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



Not applicable

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.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.