Filter

[NewbieJono]

Is there a method to not allow the user to select Day from this filer. My data only includes month.

[YalanWu_test · Accepted solution]

Hi, @NewbieJono ;

Sorry, This is by design and does not support the option to delete days.

You may vote the idea and comment there to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a 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.

Best Regards,

[amitchandak]

@NewbieJono , Use a visual level filter to remove value.

[NewbieJono]

sorry, i am not sure whayt you mean?

[amitchandak]

@NewbieJono , if you are using a slicer, In the filter pane, you can use a visual level filter to control the values you want to show, See if that can help

[NewbieJono]

it does not seem to remove Days from the options of the slicer drop down. i am guessing you can;t change the slicer options