disable the selection of the year level of the date filter which contains year and month level

[Anonymous]

Hi guys,

I have a date filter with an hierarchy ( year and month ) as following 

        

Do you know if I can disable the selection on the year hierarchy and keep enable the selection on the month hierarchy ? In fact, the user should  select only a month of any year, if they select a year, every month of this one will be selected and will occur an error to my measures.

Thank you in advance !

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

There are many ways to solve this problem.
1. Remind the user to expand the year when selecting the slicer, and then select the month of the year.
2. Combine the year and month into one keyword, and then use unique year and month keywords to create a single-choice slicer.
3. Create 2 slicers, one slicer to filter the year, one slicer to filter the month, and set both slicers to single selection.

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try single select. But that will allow one year or one month selection .

Otherwise create a month year column and use that in the slicer

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm") 

[Anonymous]

Hi

the single select is already on but when the user select a year, all months of this one are selected and it occurs errors to my measures.