Slicer not effecting line and clustured column chart

[Ella123]

I'm fairly new in power bi and I'm having trouble connecting the slicer to the line and clustured column chart visual.In the visual the requests (displayed as columns) and the actual hours (displayed as line) across months are displayed.This visual stems from  two tables (one for actual hours and the other for requests) which is in a relationship with another table with has dates (Query1) .The goal is when the slicer is not selected the visual should display as before, when the one option in the slicer is selected( a department name) then only the lines displaying the actual hours should be changed and thus i need to see the actual hours of a department varying across months with the slicer.For this ,Mika... table is used ( it's date-column ) and it is in a relationship with table Query1 ,which was essentially connected with the other 2 tables effecting the visual.The table for the slicer  is created from the mika table.Thus, i think all necessary relationships are already made but the changes are not being shown in the visual with the slicer. Any ideas?

As additional information to my question , here are the screenshots : 

 -> this was the chart i was working on and it's connected to three tables

here are the relationships :

Mika.. table : they are multiple entries of each department from 2023 to 2024

Query1 table : for month-year 

i created a slicer using mika.. table , for the department names  , but when  clicked there are no changes for the line axis of the sum of ac hours in the chart .By establishing a relationship between month-year columns of query1 and mika-- table i thought that the mika table should be indirectly connected to tablee1(4) which has the actual hours in the chart and therefore the actuals hours of a department should be shown, but there are no changes .

[Anonymous · Accepted solution]

Hi @Ella123 ,

I create four tables as you mentioned.

Then I think you can use Edit interactions.

So it will give you what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

could you pls provide some sample data and expected output?

[Ella123]

hi , i provided my data, if you have any other questions,pls ask .