Current Year Months in Month Slicer

[Tanushree_Kapse]

Hello All,,

I have a Month slicer, wherein I have pulled Month from the Date hierarchy.
This slicer is showing all the Months from Jan to Dec.
Because I have dates from Jan 2020 till April 2021

In the slicer I just want to show the current year Months... which are Jan to April.

The Top N filter for Year is not working on this.

How can I do that?

Please help!

[Anonymous]

You can create a filtered table from your date table containing the dates only for the current year like so 

Current year dates = FILTER(Sheet1,Sheet1[Date].[Year] = YEAR(TODAY()))

Then you can extract the month from the date using the format function on date 

Month Name = FORMAT('Current year dates'[Date],"MMMM")

Now when you use this calculated column in your slicer, you'll get only the months present in your date table for the current year dynamically without applying any filters manually as you asked.

Regards,

Aditya

[CNENFRNL]

Use a visual level filter

[Tanushree_Kapse]

@CNENFRNL , in this case I'll have to manually select the Current Year every time.
Can I not do it dynamically?..the slicer should display current year's months at all times.

Thanks!