Forum Discussion
Visual sort keeps reverting back??
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.
How do you change the Total Revenue value? with different measures?
I created the measures for MTD, QTD and YTD and then built them into a parameter which created the following button.
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.
That worked! I will use the measure for the visual and parameter for the rest. Thanks!
