Forum Discussion

bobbob123's avatar
bobbob123
Icon for Helper III rankHelper III
4 years ago
Solved

column chart custom sort x-axis

Hi,   I have a column chart that has the following x-axis.   I want to arrange the x-axis of my column chart to go as follows.   1,2,...10,11a,11ai,11aii...11av,11b,11bi,11bii....11bv,......
Need Help
Show and Tell
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    For the sorting to be dynamic you would need to create a measure using RANKX, and that needs an expression to rank by. 
    Another option is to create the order in Excel, which is much more flexible for these types of tasks. You can then either use that as your table or merge with the table already loaded.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

For the sorting to be dynamic you would need to create a measure using RANKX, and that needs an expression to rank by. 
Another option is to create the order in Excel, which is much more flexible for these types of tasks. You can then either use that as your table or merge with the table already loaded.