Forum Discussion
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 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.
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.
4 Replies
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.
