Skip to main content
cancel
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.

Reply
nsadams87xx
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.

 

 

Models.JPG

 

 

My "time dimension".

Time Reference.JPG

 

 

Incorrect order.

Incorrect.JPG

 

 

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

 

 

1 REPLY 1
Anonymous
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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.