Date Between Sclicer Is Not Getting Filtered In Power BI Desktop (With Updated Version April 2019)

[Anonymous]

Hi All,

I have the following 3 tables.

Date

Test Exec Date

Test Cycle Look Up

Relationships :

'Date'[Date] One To Many 'Test Exec Date'[Planned Date] Filter Direction Single from one to many

'Test Cycle Look Up'[Report Test Cycle] One To Many 'Test Exec Date'[Test Cycle] Filter Direction Single from one to many.

Problem :

Once i have created 2 slicers.

Slicer 1: 'Test Cycle Look Up'[Report Test Cycle] 

Slicer 2: 'Test Exec Date'[Planned Date]

If the Slicer 2 is List then the population of the "Planned Date" within the Slicer 2 is populating correctly based upon the selection of Slicer 1 (i.e 2019 - ITC or 2019 - UAT) but if i change the Sclicer 2 to "Between" instead of list then the date is not getting filtered based upon the lection of Slicer 1 (i.e 2019 - ITC or 2019 - UAT). It is showing the Min to Max date range.

Soo in this case Slicer 2 is not synching up with the Slicer 1's context.

I am attaching the PBIX file for your reference. Please let me know if this a product issue or it is the working as designed behavior.

PBIX File Link :

https://drive.google.com/open?id=1yAAhF4lVoMrraqU1FRYw6FyrqJXREmb5

Thanks!

Ayan

[edhans · Accepted solution]

It works fine. You have your interactions set to not filter slicer 2. To fix:

1. Select Slicer 1
2. Go to the Format tab.
3. Select Edit Interactions
4. Click the little graph/filter. You have ti set to the circle with a line.

[Anonymous]

Many Thanks for your help .

-Ayan

---

@edhans wrote:

It works fine. You have your interactions set to not filter slicer 2. To fix:

1. Select Slicer 1
2. Go to the Format tab.
3. Select Edit Interactions
4. Click the little graph/filter. You have ti set to the circle with a line.

---