I would recommend to use Veeam's Reporting utility - Veeam Reporter
It is a free base Reporting utility but you need to buy licenses for the more advanced reports
But the report you are looking for is included in the free version, and the report layout is very nice with graphs and details per VM
If you find this or any other answer useful please consider awarding points by marking the answer helpful or correct. Thank you.