Forum Discussion
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,......
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.
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.