If its just the quantity per month you are interested I would unpivot the the Open Date and Close Date fields in power query and then use the Date type as the legend. If you would like help on unpivot let me know