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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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