Stacked bar graph, fixed X, first stacked bar displays incorrect values

[war4peace]

I have a stacked bar chart which should display last 7 days of data (energy consumption, per device). By default, when the chart loads, the first day displays much larger values than it should (see screenshot 1). If I click "Autoscale" three times, the chart becomes correct, as far as values go, but an extra empty day appears at the beginning (see screenshot 2).

What I want to achieve is for the chart to always display the most recent 7 days of data, including today, with correct values.
Current YAML at the bottom.

Thank you!

Screenshot 1:

Screenshot 2:

type: custom:plotly-graph
title: Daily Energy Consumption
hours_to_show: 168
refresh_interval: 3600
layout:
  barmode: stack
defaults:
  entity:
    type: bar
    period: day
    statistic: state
    filters:
      - force_numeric
      - derivate: d
entities:
  - sensor.shellyplusplugs_d48afc470e64_switch_0_energy
  - sensor.ac_atelier_energy
  - sensor.priza_ac_dormitor_sus_switch_0_energy
  - sensor.priza_ac_sufragerie_sus_switch_0_energy
  - sensor.priza_pc_switch_0_energy
  - sensor.shellyplusplugs_d4d4da7c1efc_switch_0_energy
  - sensor.frigider_garaj_switch_0_energy
  - sensor.shellyplusplugs_d48afc4749e4_switch_0_energy
  - sensor.priza_tub_leds_switch_0_energy
  - sensor.workshop_leds_switch_0_energy
  - sensor.priza_v_core_3_switch_0_energy
  - sensor.priza_v_minion1_switch_0_energy
grid_options:
  columns: full
  rows: 8