cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tankepaus Frequent Visitor
Frequent Visitor

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 5

Re: Sort chart by selection order

Hi @tankepaus,

 

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

tankepaus Frequent Visitor
Frequent Visitor

Re: Sort chart by selection order

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.

 

Re: Sort chart by selection order

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:

Screenshot at Jan. 24 13-07-16.png

 

put the new column on your axis in the visual.

 

HTH,

Frank

Highlighted
tankepaus Frequent Visitor
Frequent Visitor

Re: Sort chart by selection order

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

a.PNG

Re: Sort chart by selection order

Hi @tankepaus

 

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