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 las...
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    When I do that I get this: ("Skapad = Created")

    • BetterCallFrank's avatar
      BetterCallFrank
      Resolver IV
      9 years ago

      Hi Anonymous

       

      ok, please add a second calc column like this

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

      (note: only two "M" here in the format) - sort the first calc column by this second column - will work :-)

       

      HTH,

      Frank