Adding a color to the apex chart series removes the previous months data from monthly utility sensor

The set up: I have a monthly utility sensor used to capture energy usage from a smart plug.

So here is the issue I am having, I use apex-charts to plot that monthly usage. And if I use the color option under series, the data from July is not shown.

Let me show you these 2 screenshots: red is with color, orange is no color.

Is this a bug or what to do about it?


Here is the code:

type: custom:vertical-stack-in-card
title: ''
cards:
  - type: custom:apexcharts-card
    apex_config:
      chart:
        height: 245px
      tooltip:
        enabled: true
    header:
      show: true
      title: Storage plug monthly
    graph_span: 1y
    span:
      start: year
    series:
      - entity: sensor.utility_storage_power_monthly
        type: column
        color: red
        transform: return x / 1000
        float_precision: 2
        unit: kWh
        group_by:
          func: max
          duration: 30d
        show:
          datalabels: true