Dynamic data selection based on date slicer in Power BI

[Anonymous]

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.

[KBO]

Hi @Anonymous ,

try this: http://analyticsavenue.com/power-bi-timeperiod-slicer-for-last-7-dayslast-30-days/

It helped me also in the beginning :).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @KBO ,

Thanks for sharing this but as mentioned in the link calulated "Period" column will not work dynamically after changing the date in Date slicer. Is there any other way to calulate dynamically and show it in filter of "Joined in last 14 days" and "Left in last 14 days" after changing the date slicer