Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a slider using a variable for value in a what-if scenario. I am showing the slider oriented vertically. I'd like the values on the slider to sort descending from top to bottom. The default behaviour is to sort ascending from top to bottom. I've tried inverting the min and max values and using a negative step value.
It's kind of a kludgy solution, but how about making your values negative.
Min: -10
Max: 0
Static Step: 1
Then format it as Money and use the format:
That way, the values appear to be positive and will be sorted in descending order.#,##0.;#,##0.
Then you would probably want another variable that was your slider variable times -1 and use that in your expressions to hold the correct intended slider value.
That would work but my range is from -.05 to .05
Thanks for thinking about it though.
I appreciate it.
The same idea would work in that situation.
Min: -.5
Max: .5
Static Step: .1
Money Format: -#,##0.0;#,##0.0
Then you still need the second variable to multiply the value by -1.