Date slicer (dropdown) missing values when another date slicer has already been selected.

[wjsullivan]

One of the pages in my report is essentially just a data with a bunch of slicer options.  It lets the end user filter by their geography, see if an order for that particular customer has been placed (order date) and if it's been shipped (ship date).  Individually each slicer seems to work fine.  But when used together, the 2nd slicer the end user manipulates doesn't show the cooresponding values after the 1st slicer has been applied.

For example, if the end user wants to know what orders have been placed but not yet shipped, they should filter the Order Date slicer to <> blanks and the Ship Date slicer = blanks.

In reality what I'm seeing is that:

1. if they filter the Order Date slicer (<> blanks) first, there are no blanks appearing in the (dropdown) list of the Ship Date slicer.
2. if they filter the Ship Date slicer (= blanks) first, the only option in the Order Date slicer is blanks.

The data essentially looks like this:

CUST	ZONE	Order Date	Ship Date
1	A	7/1/23
2	A	7/1/23	12/31/23
3	B
4	A	6/12/23	6/30/23
5	C	12/28/22	1/14/23
6	C	2/4/23	3/1/23

Using method A, setting Order Date slicer <> blanks first, blanks does not appear as an option in the Ship Date slicer.

Using method B, setting Ship Date slicer = blank first, the only option is blanks for the Order Date slicer.

All the data is in a single table.  I can see the blanks in the source data.  Exporting it to Excel I can filter without issue.

Show items with no data is checked for all slicers.

Show Select All is enabled for all slicers.

I also can't see the 12/31/23 (future) date in the Ship Date slicer with no filters applied.  The Ship Date slicer stops at today, even though there is future dates in the source data. 

Any idea why? 

[vicky_]

Basically, the filters are filtering each other. You can try disabling visual interactions between your slicers: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

[wjsullivan]

Thanks @vicky_.  The end goal is to have the slicers filter each other. 

When I disable the visual interactions, I can get method A to show blanks as a choice in the Ship Date sclicer and method B to show non-blank choices in the Order Date slicer. 

However, when I select blanks in method A or the non-blanks in method B the table shows no results.  And I still can't see the future (12/31/23) Ship Dates.

Which makes me think this might be a data or data format issue of some sort.  But everything looks good in the query preview.

The data is coming from an Oracle table.  I've added steps to the import query to ensure these fields are pulled in as date fields.