Always show last 12 month (Bar chart)

[Anonymous]

Hello,

I want to build a bar chart which always show the last 12 months (based in max(date)).

My real doubt is when i change the maxDate, the sort stay out of order. Even if i set a expression in sort tab:

Date#(date,'MMM-YYYY')

It stay in order without filter of data, filtering previous month, stay out of order. How to solve it?

Thanks

[maxgro]

hope to understand

you have a bar chart with month - year on x axis

maybe a calculated dimension =year(Date) & '-' & Month(Date)

try with sort by expression

max(Date)