Salary charts by department (BI Hub)

Currently in the BI Hub, in order to know the cost of payroll by department, I need to enter department by department and then create a graph outside the Hub.

I would like to generate a single chart that allows me to visualize earnings by department:

Example: Base date January 2025

Department A 30K,

Department B 45K,

Department c 25K.