Forum Discussion
How to Create Predefined Date Filters in Power BI Without Manual Slicer Adjustments?
Hi manoj_0911 ,
You need to get the start and end dates for each period type and then generate rows of dates using that information. Also, I don't see a difference between all time and custom. If custom, ill just show all dates and let user select a range from a slider which can me it is either custom or all time. The generated rows of dates are t hen related to the actual dates table. You can use a measure as well to filter a visual but you'll need to reference this measure in other measures if the dates are not included in a viz. Please see attached pbix.
Hi manoj_0911 ,
You need to get the start and end dates for each period type and then generate rows of dates using that information. Also, I don't see a difference between all time and custom. If custom, ill just show all dates and let user select a range from a slider which can me it is either custom or all time. The generated rows of dates are t hen related to the actual dates table. You can use a measure as well to filter a visual but you'll need to reference this measure in other measures if the dates are not included in a viz. Please see attached pbix.