Sorting a bar chart within a date group

[jamestieu1]

I am trying to sort sums on every specific date. There are rates that are valid to the end of every month.

For example, June 30, July 31, etc.

I want the bars to show up in ascending order within those dates.

I can't sort on total because it will make the dates out of order.

I also created a rankx and tried to sort the bar chart on that and experienced the same issue. It seems like the bar graph is summing the rank values by month and then re-ordering the months.

rank = RANKX(FILTER('shipment rates 1','shipment rates 1'[routing_details_effective_end_dt] = EARLIER('shipment rates 1'[routing_details_effective_end_dt])), 'shipment rates 1'[Final Total],,ASC,Dense)

Does anyone know how to do sort by totals on a specific date on the x-axis? For June 30, the bars should be sorted in ascending order. For July 31, the bars should be supported in ascending order. 

And the x-axis dates should not move at all.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.