Watch the video above to learn how to set up a custom date period slicer in Power BI! In this example, we allow the user to select from MTD, QTD, YTD, Last Month, Last Quarter, Last Year, All Time, and Custom!
The Custom option is extremely cool because it will enable the user to set a custom date range, other than the pre-defined date period selections. See the following gif for an example.
I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!
Hi! This is so useuful, but I was wondering How do you add the WTD into the filter? or for example last 28 days, etc. Thanks
[…] I came across an insanely entertaining fresh video from Parker Stevens about Custom Date Period Selections in Power BI (yes, I know, not very fresh – I rarely enter the Internet these days, just look […]
Great post. Is it also possible to use custom date periods with parallel periods?
If I select a custom range and then change to last year (for example), the first selector of the slicer seems to get stuck on the date I set in the custom setting. It only seems to function properly if I don’t try and do a custom range and then a predefined range. Am I doing something wrong?
Thanks a lot . But I’ve a problem .I want to use the date range selected (with your slicer) with some Time intelligence function.
For example I need to retrieve the sum of page Views for the same period of previous year : Calculate(SUM(metrics[pageViews]),SAMEPERIODLASTYEAR(‘Date'[Date])) .
I’ve to change the type of join between the 2 tables Date Period and Date to have the right result.
Can you help me ??? There’s a solution ?
Thanks for sharing.
This solution works fine but required user to reset the Custom date range slicer before switching to predefined range. If custom date range slicer is not reset, the result from predefined range is not correct.
Is there anyway to reset the custom date range filter automatically when user select a predefined range?
Hi Parker–Any idea on why I show dates in 2023 in my YTD filter and November 2023 in my MTD?
Hi Parker,
I love your solution and have implemented it but have run into a problem. When I use the pre-defined selections as I have them defined (your MTD, Last 30 days, etc.), my line chart shows ALL the dates in the master date table as 0 but correctly charts the selected range. Your example does not have that issue. When I switch to the custom date range, the chart correctly only shows the selected dates. I have no idea how to fix this. Do you know what might be causing this?