Change Sort order of Table / Chart with Slicer

I have an interesting problem to which I am hoping you can assist as haven't seen this one on any forums.

I am using powerpivot and although I know who we can use slicers to change the measures shown in the the pivot tables / charts, I am wanting a slicer that can change the sort order.

For example, the user would be able to select on of the options on the slice and the data / chart will change its order from Date to Spend, or Cost, or Profit, etc., etc..