Job Market Data Analysis using Excel

I have a set of sales records already loaded into Power BI and backed by a MySQL database. I need a clean, reusable solution that returns the yearly sum of sales for each product category and shows it in a bar chart inside my existing Power BI report.

Here is what I expect:

• A SQL query (or a view) that aggregates the data in MySQL by category and calendar year.
• A corresponding DAX measure or calculated table in Power BI that consumes that result so the numbers stay synced if the database refreshes.
• A bar chart visual, styled to match the current report theme, displaying each category on the x-axis and the yearly totals on the y-axis. The visual should automatically update when new years or categories appear.

Please keep field names identical to those already in the model and document any transformations you add so I can maintain them later. Once the file is returned, I’ll plug it into the report and confirm that the totals and drill-throughs work as expected.