Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting Stacked Bar Chart by Axis Values

Hi Member, 

 

In the following Graph- I am looking to sort the values on Axis (Screen Time) either ascendingly/ descendingly.

Can anyone suggest how do i proceed. 

 

 

 

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Do not write a calculated column formula.  Write a formula in the Query Editor instead

     

    =If [Status]="Considered" then [Interview Date]-[Application Date] else null

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    In the Data Model, it looks like to the screen time column is formatted as a text column.  Change the formatting to Numbers.

     

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      And yes, Ashish- It was formatted as Text earlier.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        So does the graph now pan out correctly?  If yes, then please mark my reply as Answer.