You can try and use Microsoft 365 usage analytics within Power BI. This tool allows you to visualize and analyze Microsoft 365 usage data, create custom reports, and share insights within your organisation. It provides a prebuilt dashboard with a cross-product view of the last 12 months and other prebuilt reports.
You can also customize these reports for more personalized insights. For example, you can modify existing visuals or create new visuals to track the usage of specific products on a monthly basis. If you need to join this data with other data sources for richer insights, you can use Power BI Desktop.
If you find this response helpful and it resolves your issue, please consider marking it as “Accepted” or giving it an upvote. This will help others in the community find the solution more easily.