I have 2 columns for month, one displays the month name and the other the month number. This is to allow me to sort the month names correctly (e.g. Jan, Feb,.....Dec) by sorting the month name column by the month number column.
Usually this is done by using the "sort by column" tool but it seems to not be avaialble for any of my columns, the option is greyed out in PBI. I also can't create any new columns either.
I should note that my data comes directly from Alteryx via the Power BI service and appears under "my workspace", which I assume is the reason why it doesn't work. Does anyone have any ideas how I can sort these months?