Forum Discussion

jimmypopiel's avatar
jimmypopiel
New Member
7 years ago

Multiple Slicers not working

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 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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