I created this Dashboard to display the units consumed and the respective cost for Selected filters.

This Dashboard will be helpful for any Azure Customer, irrespective of their contract agreement with Microsoft.

Customers can view their usage and cost by uploading the Usage files into this Power BI file. Check the attached setup pdf file for details on setting up this dashboard.

Please note that all the screenshots on this page are mock-up screens; hence each screen data will differ. These screens are captured to show you what the screen looks like based on the data you will be uploading.

• Azure Cost Management Dashboard
  • Filtering
• Monthly Usage and Purchases Dashboard
  • Monthly Cost View
  • Monthly Usage Cost View
  • Monthly Purchase and Refunds Cost View
  • Monthly Usage and Cost by Service
• Daily Usage and Purchases Dashboard
  • Daily Usage Cost
  • Daily Purchase and Returns
  • Daily Cost by Service
• Resource Level View Dashboard
  • Daily Usage Units and Cost for On Demand, Reservations and Savings Plans
  • Top 5 Subscriptions drivers contributing to the cost
  • Top 5 Instance Types drivers contributing to the cost
  • Top 5 Resource Locations drivers contributing to the cost

This Dashboard helps customers to understand the billing details, including monthly bill, monthly usage cost, and monthly purchase cost, along with the number of units each Service consumed and the respective cost by Services running on On Demand or Reservations or Savings Plan with the Top 5 drivers contributing to the cost. These drivers are the Top 5 Subscription Names, Top 5 Instance Types, and Top 5 Locations. Customers can view details of any Service monthly and daily insights of usage and respective cost with a granular level of drill down to Resource Name.

Customers can filter the Usage details by Meter Category / Service, Meter Subcategory / Instance Type, Date, Subscription Name, Tags, Resource Location, Resource Group, and Resource Name. These filters can be helpful if you need to view usage and cost based on specific criteria.

For Example, Customers want to view the usage details by specific subscriptions or based on particular tags or months.

This dashboard displays Monthly usage cost, purchase cost, and service cost for selected filters from the filters dropdown section

Monthly billed amount for selected filters from the Filters dropdown section

Monthly usage cost for selected filters from the filters dropdown section

Monthly purchase and refund cost for selected filters from the filters dropdown section, followed by all the purchases made.

Cost by Meter Category month-wise with a granular filter to drill down to see Subscription Names, Resource Locations, Resource Groups, and Resource Names.

This dashboard displays Daily usage cost, purchase cost, and service cost for selected filters from the filters dropdown section

Chart displaying the day-wise cost for selected filters from the filters section.

Chart displaying the day-wise purchase and refund costs for selected filters from the filters section.

Chart displaying the day-wise costs for selected filters from the filters section.

Detailed resource details of units ran on On Demand, Reservations, Savings Plan, Top 5 Subscription Names, Top 5 Instance Types, and Top 5 Resource Locations drivers contributing cost

Chart displaying the number of units consumed and the respective cost day-wise for selected filters from the filters section, followed by the display of 4 tables:

• Daily Usage Units and Cost - All the services
• Daily On-Demand Usage Units and Cost - Services running on On-Demand only
• Daily On Reservations Usage Units and Cost- Services running on Reservations only
• Daily On Savings Plan Usage Units and Cost - Services running on Savings Plan only

Each table above displays Meter Categories, consumed units, and respective cost month and day wise, with a granular drill down of Meter Name, Month, Subscription Names, Resource Locations, Resource Groups, and Resource Names. The month column in the table will be helpful when multiple months are selected from the Date dropdown filter to view the cost of each month.

Daily On Demand, Reservations, and Savings Plans display of consumed units and respective costs will be the same as the below Chart.

Chart displaying the top 5 Subscription Names contributing to the cost day-wise, followed by a table consisting of all the Subscription Names, Meter Names, Resource Locations, Resource Groups, and Resource names to view how many units each resource utilized along with cost day-wise.

Chart displaying the top 5 Instance types / Meter Names contributing to the cost day-wise, followed by a table consisting of all the Meter Names, Subscription Names, Resource Locations, Resource Groups, and Resource names to view how many units each resource utilized along with cost day-wise.

Chart displaying the top 5 locations contributing to the cost day-wise, followed by a table consisting of all the Resource Locations with a granular drill down of Subscription Name, Meter Name, Resource Group, and Resource name to view how many units each resource utilized along with cost day-wise.

I welcome any feedback or suggestions on this dashboard! If you find any bugs or have ideas for improvements, please create an issue on this repository, and I'll get back to you as soon as possible.

To create an issue, click on the "Issues" tab at the top of this page and then click the green "New Issue" button. Please provide as much detail as possible about your issue or suggestion, including any steps to reproduce the problem or implement the recommendation.

I appreciate your help in making this Dashboard better for everyone!