When filter, the order of months does not work well

Lala — Tue, 12 Nov 2019 10:32:24 GMT

I have a bar chart that should show the current month and the previous 13 months.

On the x-axis I make a concatenation of year and month (the written month, not in number). This is my fx:

=if (GetSelectedCount(AÑO)=0 AND FECHA>=(Monthstart(Addmonths(TODAY(),-12))) AND FECHA<=TODAY(),
AÑO& ' ' &(MONTH(MakeDate([AÑO],MES))),
if(GetSelectedCount(DMES)<>0 AND FECHA>=vLimiteMenor AND FECHA<=vLimiteSuperior,
AÑO&' '&IF(LEN(MES)=1,'0'&MES,MES)
))

*DMES means written month
*MES means numer of month
*vLimiteMenor means =(Monthstart(Addmonths(DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY'),-12)))
*vLimiteSuperior means =DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY')

When I filter, I also need to view the filtered month and the previous 13 months, so I used different methods: alternate states, method {1}... BUT WHEN FILTER, the order of concatenation does not work well.

Can someone help me? I do not know what I'm doing wrong

topic When filter, the order of months does not work well in App Development

When filter, the order of months does not work well