Forum Discussion
Transpose axis values in chart
Column values are always sorted alphabetically by default. You can override this by setting a sort by column in the table designer. You could create a calculated column wth a switch statement to create a numeric ordering
CategoryOrder =SWITCH( [Category]
, "Projects under $20K", 1
, Projects $21K - $50k, 2
etc...
)
Then click on the [Category] column in the field list, switch to the "Modeling" tab on the ribbon and click on the "Sort by Column" button and choose the new [CategoryOrder] column.
I also typically hide any ordering columns like this one as they are only needed for overriding the default alphabetical sorting.
Column values are always sorted alphabetically by default. You can override this by setting a sort by column in the table designer. You could create a calculated column wth a switch statement to create a numeric ordering
CategoryOrder =SWITCH( [Category]
, "Projects under $20K", 1
, Projects $21K - $50k, 2
etc...
)
Then click on the [Category] column in the field list, switch to the "Modeling" tab on the ribbon and click on the "Sort by Column" button and choose the new [CategoryOrder] column.
I also typically hide any ordering columns like this one as they are only needed for overriding the default alphabetical sorting.
Thank you. I was also able to apply the same approach to the conditional column that I had created initially. I did not work until I used the Sort by Column command.
Steve