Hello,
I'd recommend loading the Azure Cost Management addon in Power BI to display this data:
Create visuals and reports with the Azure Cost Management connector in Power BI Desktop
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management
When you get to the step of choosing how many months, you can put 12.
If this is helpful please accept answer.