Sorting with Help of a Button

[bharani8]

Hi Experts - I have a chart... Am trying to figure out whether we have an option like.. On click of an button, My dimension (which is sorted based on my expression) should change from Asc to Desc and vice versa...

Regards

Bharani

[sunny_talwar]

You can do that using a sort expression within your chart and a variable...Basically, based on a variable value, you can change the sort expression like this

If(vVar = 1, Sum(Measure), -Sum(Measure))

[sunny_talwar · Accepted solution]

Check the attached sample

[bharani8]

Wowwwww!! U r an Star!!   TY so much!!

[bharani8]

Will try to incorporate in my DB and let u know how it goes ..

[effinty2112]

Hi Bharani,

                    I'd like to contribute something which works along with Sunny's solution.

Create a button with text : =if($(vVar) = 1,'Asc','Desc')

and give it the action to change the variable vVar to: =1-$(vVar)

Clicking this button will toggle the value of the variable between 1 and 0 and change the sort order in your chart.

Cheers

Andrew

[bharani8]

TY Walker for taking your time to post this!!

I was not able click on that "Mark as Helpful" as it keeps on loading.. Any ways Thanks..

[sunny_talwar]

Hey Andrew -

Where exactly do we add this expression? Can you update my sample to show how it would work?

Thanks,

Sunny

[prieper]

as action on click:

You only need to set vVar initially to either 0 or -1 ...

[sunny_talwar]

Where will this go?

=if($(vVar) = 1,'Asc','Desc')