Multiple Slicers not working

[jimmypopiel]

Hi 

I am trying to filter my data according to three different periods of time:

1 - Total: Report Period: (19/07/19 to 21/08/19)

2 - Backlog Period: (19/07/19 to 07/08/19)

3 - Last Week Period: (08/08/19 to 14/08/19)

4 - Next week Period: (15/08/19 to 21/08/19)

However, I am getting the wrong result for the data range number 03 (Last week Period), which shows the data results from the range number 2 + 3. The other ones are ok and the results are correct.

To get the desired results I am editing the interactions, set ON or OFF according to what I need to see, but it seems that this way is not the best one. 

Here below a screenshot 

[v-shex-msft]

HI @jimmypopiel ,

It is hard to troubleshoot your formula without any sample data, can you please share a pbix file with some sample data for test?

Regards,

Xiaoxin Sheng