manipulating labels in the x-axis

[#1]

Hi,

I have big integer keys on the x-axis, like 100032, 2000012 etc

Is there a way I could sort these and display just 1, 2, 3 and so on in order instead of their actual codes.. I still want these keys to work as they are working, I just want to have 1 instead of 100032, 2 instead of 2000012 etc for visualization purposes..

is there a way to achieve this?

Thanks!!

[#2]

Try the attached... notice that I have specified the Sort Order to be Numeric Ascending in the bar chart - so it is displaying in ascending order, even though the load order is different as shows in the table box on left. Hope this solves the problem.

[stigchel · Accepted solution]

Yes you can, disable the show legend of the Dimension, add an expression (make it the first by promoting it) and in the display options check text on axis and deselect any other display options like bar/line/symbol.

For the expression you can use an expression that will give you the required numbering (rowno()/columnno(), rank(..))