u/EquivalentBus2907

I’m working on a Power BI dashboard and stuck on a filtering issue.

Requirement:
Courses that started before the selected date range but are still ongoing should still appear in the dashboard.

Current setup:

• courses table → contains course_id and status (Ongoing / Completed / Upcoming)
• enrollments table → contains student enrollments with dates
• Relationship: course_id (bidirectional)
• Date slicer is based on the enrollments table

Problem:
When I apply a date slicer, it filters enrollments → which then filters back into courses.
As a result, courses with no enrollments in that date range disappear, even if they are still ongoing.

What I tried:

• Changed to single-direction relationship → didn’t solve it properly

Question:
How can I prevent the date slicer from filtering out ongoing courses that don’t have enrollments in the selected range?