Date Filter to filter records based on two date fields
I am working on Change Request reports, In data set i have Scheduled Start date and Scheduled End Date. I like to have a date filter(date Slicre) to perform the following criteria: example : User Pick date range 01/01/2019 and 15/01/2019 results like to see : any records that has Scheduled Start date or Schedule End Date fall between above dates
Date Slicers and Relative Date filtering - Allowing users to updates dates beyond date bounds
Hi - I'd like to default date slicers to last month (updating each month automatically) but allow users to change the dates if necessary. Adding a relative date filter to that slicer accomplishes the first part but it seems that it doesn't allow the user to change the dates to anything outside the dates selected in the filter. .e.g I set the relative date filter to last month. The date slicer that defaults to 12/1/17-12/31/17. I'm unable to update the date filters to anything before 12/1/17 or anything after 12/31/17 (only in between). Is there a way to accomplish this? Thanks, SDate Slicer options (btwn, before, after, relative) appear in desktop but not in report server
I'm using a date slicer in a pbi desktop report. I set the Header option to on (in format tab) so I can see the following options when I select carrot icon by the eraser (in the slicer): "Between" "Before" "After" "List" "Dropdown" "Relative" (all of which work fine/as expected) I save the report and post it to the Report Server, but those options do not appear. Is there a way to display them so users can slice on the date using the options above? desktop: Thanks
