Dynamic data selection based on date slicer in Power BI
Hi I am working on one of the dashboard but stuck somewhere while development. So below is the scenario: I have 3 data sets with below columns: Set 1: Student ID, Enrollment date, Left date and Score Set 2: Date (Calender date of year 2019) Set 3: Measure Name So here, i wanted to create dynamic slicer using “Measure Name” column for those student “Joined in last 14 days” and “left in last 14 days” using “date” column. For example: if i selected “9/30/2019” date in date slicer and select Filter “Student Joined in last 14 days” then my data will filter dynamically based on my selection. Can someone please suggest me solution on this . I am attaching test file for your reference.
