Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |