Forum Discussion
Default Slicer setting
We have 4 years of data i.e from the past three years and a year of future data.
we need to add a slider slicer to the date field. The slicer should be selected default for the current month (MTD) is this possible by not adding an additional column in the calendar table?
3 Replies
- IdrissshatilaSuper User
Hello,
You can use relative date as shown in the following link https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
- Mahesh0016Super User
>> Select This and month.
AzaharoddinSk If this post helps, please consider accept as solution to help other members find it more quickly.
- AzaharoddinSkFrequent Visitor
The requirement is I want a total 4 years of data in the slider slicer, and by default, it can only show the current month's data, and when I move that slider it can show as per selected dates in 4 years of data, is that possible?