Hi All, I am having issue related to slicer with between format.

[Anonymous]

Hi All,

I have 2 slicers in my report, 1 slicer having custom period value and another slicer is having date with between format as given below.

Now, the issue is that based on custom date range selection, the other slicer value is not changing but it works fine if I change the slicer format to vertical list or dropdown. 

[Anonymous]

Hi Charbel,

If you encountered the similar issue, can you kindly assist me with the solution?

[CharbelArmaleh]

Hello,

Can you check the interaction if is is set to interact in both direction 

[Anonymous]

Hi Charbel,

Yes, it is set to interact in both direction. 

[CharbelArmaleh]

Hi

the 2 slicers are using the same column, if not can you show us the model or at least the relation between the 2 tables 

[Anonymous]

Both tables have one to may relationship with filter in both direction as shown below. 
The specialDates table is a calculated table derived from date table.

[CharbelArmaleh]

Ok

one more thing to verify 

the data in both columns have the same type 

and both have a full date 

[Anonymous]

Yes, both the date columns are of same type in dd-mm-yyyy format.

[CharbelArmaleh]

The format is not the type can you post a screen of both date columns as ai had the same problem before

[Anonymous]

PFA below screenshot.