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

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

Reply
Tihannah
Resolver I
Resolver I

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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