This is a very common questions that I got asked by customers. They would like to customize the report of the GCP billing with their own standard and have multiple ways to analyze the consumption. This can be done other than using built in dashboard by the billing console, you can also export the billing to BigQuery and do the analysis.
Cloud Billing export to BigQuery enables you to export detailed Google Cloud billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset that you specify. Then you can access your Cloud Billing data from BigQuery for detailed analysis, or use a tool like Google Data Studio to visualize your data. You can also use this export method to export data to a JSON file.
To get more detail on this, please see the step by step and query examples in here: https://cloud.google.com/billing/docs/how-to/bq-examples?hl=id