Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tihannah
Resolver II
Resolver II

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.

1 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.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

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.
Button.PNG

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.