Forum Discussion
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.
2 Replies
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!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
