Best Of

The reason why it is sorting in the way it is currently presented is because the months are in text value. Since it is being sorted in ascending order, it is sorting from A to Z (Feb, Jan, Mar). The easiest solution would be to drag-and-drop a date field into the "Sorting" section (Order Date in your provided screenshot could potentially work). Then sort the table in ascending order to achieve the results you are looking for.

There are a lot of ways to accomplish this but the easiest is probably to just drag whatever column you're using for date into the "sorting" section in chart properties.

You can also create a beastmode and add that beastmode to the sorting section:

month(your_date_column)

The above options work as long as month 1 is January and Month 12 is December in your data

Yeah, the null handling ain't great. If you're using an ETL and have access to the R/Python tiles, you could handle all your nulls in all your columns with a quick script:

library(dplyr)
library(tidyr)
library('domomagic')

input1 <- read.dataframe('Alter Columns 2')

input1 <- input1 %>% 
  mutate(
    across(everything(), ~replace_na(.x, 'Something to replace your NAs with'))
  )


write.dataframe(input1)