Dates in charts

Hi,

I'm a bit stuck with the charts. It feels like a basic functionality that hasn't been fully polished but my main issue is with the dates. I have a json that returns a string in date (or an epoch) with a value and the json looks like this:

[
    {
        "datax": "2024-12-01T00:00:00",
        "datay": 1000.0
    },
    {
        "datax": "2024-12-02T00:00:00",
        "datay": 986.1649687740455
    },
    {
        "datax": "2024-12-03T00:00:00",
        "datay": 986.2582957607323
    },
etc....

when enabling the label on the x axis it hangs (unless as pointed in another post, you increase the value of the interval to match the epoch).

I need a solution do display the date in a specific format (e.G.: dd/mm/YYYY) in the x axis. I've tried adding the date into a row but there's always misalignment and it's just a dirty workaround.

also, is there a way to hide the first and last values in the chart?