Defining axis range using expressions

[AdrianS1]

Hi guys i want to have a chart witch show sum of sales per days.

I Have two columns Order_Date and Sales

How i can filter this X Axis to show only last 60 days ? Is it possible?

[MayilVahanan · Accepted solution]

Hi

Try like below
Sum({$<Order_Date ={">=$(=Date(Max(Order_Date )-59))<=$(=Date(Max(Order_Date )))"}>}Sales)