Sort chart by selection order

[Anonymous]

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.

[BetterCallFrank]

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]

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]

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]

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

[BetterCallFrank]

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