Forum Discussion
Creating a Date Slicer with a Fixed Range
Anonymous , defaulting date range for last 30 in not possible.
You need to try an option like
Community SupportHi Anonymous ,
Relative date type in slicer can only depend on the current date, but not the filtered date.
The below thread answers such problems in detail.
Required custom date Slicer Last 7 days,last 15 da... - Microsoft Power BI Community
The logic is not to put the value directly in the visual and filter it, but to write a measure to calculate value of the last 30 days based on the selected date.
As the date table has no relationship with the sales table, so the slicer with date in date table cannot filter the other visual, then based the selected date in the slicer to calculate the date 30 days ago, according to the date range, calculate the value in the measure, then put the measure in the visual.
Please feel free to let me know if you have other confusion.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply, I'll try following the steps in the other thread and see if I can manage to reproduce this.