Forum Discussion
bobbob123
Helper III
Helper IIIcolumn 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.
PaulDBrown
Community Champion
Community ChampionYou need a column in the axis table which establishes the order you need. If the values are in the right order by default, you can add an index column in Power Query. If not you will need to create the order with a conditional column in Power Query or using SWITCH in the table.