Forum Discussion
Solved
Visual sort keeps reverting back??
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 highe...
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?