Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
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!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |