Visual sort keeps reverting back??

[Tihannah]

I have a bar chart visual displaying revenue by type and am using a parameter that allows the user to click between MTD, QTD and YTD for Total Revenue. I want the visual sorted by Total Revenue highest to lowest, but no matter how many times I set the sort by Total Revenue, once you change the selection to another date period, it reverts the sort back to Type instead of Revenue? It's a small thing, but it's driving me nuts as I want the user to see it's top performers without having to re-sort every time. Am I missing something?  I've never had this issue before.

[lbendlin]

How do you change the Total Revenue value? with different measures?

[Tihannah]

I created the measures for MTD, QTD and YTD and then built them into a parameter which created the following button.

[lbendlin · Accepted solution]

Try without a parameter. Although it may result in the same issue as you are swapping out and then in the column the visual relies on for sorting. 

- create a measure that reads the button selection and then provides the value based on a computation in the same measure (try to avoid nesting measures). 

- use the measure instead of the parameter

- sort by the measure.

- change the selection and see if the sort stays.

[Tihannah]

That worked! I will use the measure for the visual and parameter for the rest.  Thanks!