Issue with Custom Date Period Slicer: Missing Rows in Multiple Charts on Dashboard

Hello Power BI Community,

I’m experiencing an issue with implementing a custom date period slicer across my dashboard, which contains multiple charts. The slicer works as expected when applied to a single chart, but when used across the entire dashboard, I notice that many rows are missing from my visuals.

Details of the Issue:

1. Setup:
- I’ve created a custom date slicer using a `Date Periods` table with predefined options such as Month-to-Date (MTD), Quarter-to-Date (QTD), Year-to-Date (YTD), Last Month, Last Quarter, Last Year, and a Custom option.
- The slicer works when there is only one chart on the dashboard but the are many missing rows from my visual.

2. Problem:
- When applying the slicer across single or multiple charts, I’m getting incorrect results, and many rows are missing from the visuals.
- It seems like the slicer is not filtering all the charts as intended, or there might be an issue with the filter context affecting the charts differently.

3. Expected Outcome:
- I want the custom date slicer to work consistently across the entire dashboard, accurately filtering all visuals according to the selected date period.

4. Attached PBIX File:
- I’ve attached the PBIX file for reference. Please review the setup and let me know if you spot any misconfigurations or if there are any suggestions to resolve this issue.

I appreciate any guidance or suggestions on how to fix this issue. Thank you in advance for your help!

Attachments:

REFERENCE FILE

https://drive.google.com/file/d/1QH416a-Z3IwH_TRWbGc0C2Vjoaa--mF_/view?usp=sharing

REPORT A PBIX FILE

https://drive.google.com/file/d/1Ma78MfYuMbmaVJc5qOYAi8Mcrc4DBJYE/view?usp=sharing

REPORT B PBIX FILE

https://drive.google.com/file/d/1nIbCOA0e22LD9u-jKxPvRbonZ6Ce35_j/view?usp=sharing