Some visualizations do not change to when I use new slicer. I have loaded data from three excelfiles

[Anonymous]

Hi!

I'm having trouble, some visualizations do not change to when I use new slicer. I have added two new slicers to filter the country and to filter FY year. I have loaded data from two excel sources, I7 table1and I7 targettrainees are two tables in two spreadsheets in same excel. While calander table is created in power bi. All visualizations below except gauge one has data from I7 table. While gague data are from I7 targettrainees table. When I click the slicers, all other vidualizations work but gauge does not. That is when I get the slicer data (from I7 targets sheet or calander). If I get slicer data from I7targettrainees, it only work for gague visual and not the others. I think I need to fix the datatable or create a relationship with I7table and I7targettrainees but I'm not sure how to. 

[Idrissshatila]

Hello @Anonymous ,

You should link the calendar table with both of the tables you have in order to filter them both using the slicer