date slicer
7 TopicsDate Slicer - Latest Date
When using a date slicer it would be great if it existed an option "earliest date" (or latest). The issue is that when you have a table that is constantly adding new records, with a date column, the default status of the slicer gets outdated. Example: the default status of the slicer, and where the bookmark was saved is on period 2019.05. When a new record 2019.06 is added to the table, the bookmark needs to be saved and bookmark updated, this every month. I know there are DAX workarounds, I am using them, but an "latest date" option on the date filter would save us this extra work.42KViews154likes10CommentsA Between option for the Relative Date Filter
Hello Everyone, A common issue i often come accross when building reports is finding the best way to show date filtering and also keep the dates dynamic. The Relative Date option for the Slicer is an awesome tool, but it sadly has a major drawback. My customers are not able to both view back and forward in time at the same time. This is especially an issue when dealing with forecasts, since holding a forcast up to historic values is very important. What i suggest is to add a "Between" or "Combine" option under the "Last", "Next" and "This" options. So the customer can choose to see 4 months back and 3 months ahead for instance, since today this needs to be hardcoded into a calendar table, if the date also needs to move dynamically. I believe that this change would please a lot og users and make the "Relative Date" option much more useable. Thanks in advance2.9KViews13likes0CommentsAllow change of Date Filter for Service and Embedded
Hi, In our organization we alwasy use the "Relative Date" as the standard mode for the Date Filter. When talking to users many like the feature for its useability but just as many are asking if they can select a specific period, and we have to tell them no. Sure this can be optained through highlighting periods in a table or visual, however this fix is "temporary" for the user and not a hard filter across pages. The function is avaliable in Desktop through the "Slicer Header" to change it but i cant give that option to the user in service or embedded. Please make the "Slicer Header" customization avaliable for users in Service and Embedded as well:2.1KViews0likes0CommentsReset Slicer for Dates with quarters and months
Hi All, Based off my colleagues post on the forums: Reset Slicer for Dates with Quarters and Months To summarise: If you have 3 date slicers Year, Quarter and Month and you have selected January from the month slicer. Lets now say you now wish to select Quarter 2 from the Quarter Slicer, the January Month that was selected previously is still visibile Is there a way of implementing such logic that the month selected is automically deselected when you select a different quarter? Please see link above for screenshots and added detail Thanks, Nuemio Thanks, Nuemio3.5KViews1like0CommentsDate slicer: obtain start date and end date from calculated columns or measures
Hi all, I would suggest an idea to improve date slicer. It could be beautiful if you could set start date and end date of the slicer with a value given from a calculated column or measure. For example, it could be beautiful if you could set Start Date = NOW() End Date = Start Date + 15 days (or Start Date + 30 days, or StartDate + 7 days... And so on :) ) End Date could change dinamically based to the Start Date Value (NOW()). What do you think about? Cheers.14KViews13likes4Comments