Forum Discussion
Date slicer (dropdown) missing values when another date slicer has already been selected.
Super UserBasically, 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=powerbi-desktop
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.