static bar chart over several years

Hello everybody,

I need your help again, solve my little Power Bi problems. :-)

I want to create a bar chart, which shows me cumulated disease-days per department over several years.

I have to tables, the first one contains three columns:

Posting Date, Job description (#Sick), Department, Hours required

The second one is calender table. Both are connectd by date.

The solution in bar chart should be:

2015 - Purchase - 8hours - sick

2016 - Sales -8hours - sick

2017 - Production - 8hours - sick

2017 - Sales - 8hours - Sick

2017 - Purchase 8hours- Sick

and so on...

I´ve a second issue, the bar chart should be static. It´s part of a report, but it shouldn´t change if other tables or charts are changing by using a filter.

I hope my explanation is clear enough.

I´m thankfull for every help or solution! :-)

Thanks alot!

freiburgc