Forum Discussion
Date Slicer Slider Control
Hi trevrobwhite2 ,
As you mentioned, even if your data only includes dates on the 1st of each month, the slicer slider can still move to other dates when the “between” type is selected. Based on my testing, there doesn’t appear to be a way to restrict it to only the 1st of each month when using this type. However, this does not impact the accuracy of your values. You can also submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Additionally, you can select the dropdown type or choose the slicer type to be a vertical list, ensuring that only the 1st of each month is displayed.
Best Regards
Hi trevrobwhite2 ,
As you mentioned, even if your data only includes dates on the 1st of each month, the slicer slider can still move to other dates when the “between” type is selected. Based on my testing, there doesn’t appear to be a way to restrict it to only the 1st of each month when using this type. However, this does not impact the accuracy of your values. You can also submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Additionally, you can select the dropdown type or choose the slicer type to be a vertical list, ensuring that only the 1st of each month is displayed.
Best Regards