Sort by other values that change with filters

[sohagan]

Hi 

I am trying to sort by another column based on a calculated column in another table. This works fine but when I put in a date slicer on the visual the sort order stays in the order of the totals not on the filtered values.

Is there away so that the sort order reflects the filted values?

Thanks

Steve

[Anonymous]

I am having a similar problem where the dates are ordered fine in my slicer, but when I click the elipses to "sort by date" in my slicer, it then sorts in alphabetical order. I checked the model, and the data type is date, but the data category is "undefined" and I don't see an option to change it.

[Melvlee]

Can you provide some sample data and explain the relationships between your tables?