static bar chart over several years

[Anonymous]

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

[Stachu · Accepted solution]

I may be wrong, but I think you can achieve that with the visuals settings:
1) create the chart
2) fitler Sick only on visual level
3) disable filter interaction with other charts

[Stachu · Accepted solution]

I may be wrong, but I think you can achieve that with the visuals settings:
1) create the chart
2) fitler Sick only on visual level
3) disable filter interaction with other charts

[Anonymous · Accepted solution]

@StachuThanks for your help.

I solved my problem with that thread:

https://community.powerbi.com/t5/Desktop/Want-to-disable-automatic-filtering-on-visuals/td-p/203347