Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Sort chart by selection order

Is it possible to sort by selection in slicer? If I select february 2016 to januari 2017 I want to see february in the chart as the first bar on the left followed by march... until january is the last bar in the chart.

 

5 Replies

  • BetterCallFrank's avatar
    BetterCallFrank
    Resolver IV
    9 years ago

    Hi Anonymous,

     

    can you give us a screenshot of your data?

    What data type/columns do you have in your data?

    Do you have a date table?

     

    without having seen any of your data: you need an additional column, e.g. saying "2016-12", "2017-01" etc - this would be the easiest way to make it sort like you want 

     

    HTH,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I have this:

       

      Table Names

      Name Created
ABC 2016-02-01 13:12:28
DEF 2016-02-07 11:07:00
GHI 2016-02-07 11:10:52

      Then in the chart I have a date-hierarchy on the axis and I have deleted Year, Quarter and Day so Month is the only one left.

       

      • BetterCallFrank's avatar
        BetterCallFrank
        Resolver IV
        9 years ago

        quick solution would be to add a calc column:

        YYYY-MM = FORMAT( Table[Created], "YYYY-MMM")

        Then make the new column be sorted by Created column:

         

        put the new column on your axis in the visual.

         

        HTH,

        Frank