Sort report data in descending order without affecting time series charts
I am trying to create a report where data is sorted in descending order with latest date on the top. The issue I am facing is my time series chart also gets affected when I sort data (see chart 1). When I keep the time series option on chart breaks( see chart 2) . Am I missing anything here?
I want to sort the data in desc order by date and still keep the charts from left to right in ascending order