Show month where there is no data in a histogram

this is my postgreSQL query :

    count(*) as number,
    to_char(event.creation_date, 'MM-YYYY') as my_date
 FROM event 
JOIN event_resources ON 
WHERE {{date}}
GROUP BY my_date
ORDER BY min(event.creation_date) asc;

and this is my result :

i would like each mm-yyyy to appear event when number=0. i can't change the x-axis scale (it is on ordinal). for instance, 01-2020 doesn't appear on this graph

can someone help ?
have a nice day

Hi @armandviolle
You would have to make a query to a table, which has all the dates you're looking for and then join in your other query, which fills it with the data you want.