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