How to restrict Date Hierarchy up to current date in a Slicer.

[suparnababu8]

Hi @community15 

I have date in my data model from 1st January 2024 to 15th April 2024. Based on this I created a Calender table. When I drag this date into a slicer and by right clicking on date in the filed and check to Date Hirearchy. It is showing full months ( Jan 2024 to Dec 2024) and date for the year of 2024. 

I need only upto current date with date hirearchy option.(Year- 2024, Months - Jan,Feb,March and April, Day - upto 15th of April)

If any help that would be great.

Thanks in advance!!
@Como @mFabric  @Mic  @Ejemplo  @AilleryO  @timalbers @v-jageo @v-yangliu-msft @Anonymous 

[suparnababu8]

Just a note: If am enabling Hirearchy it's not working. without Hirearchy it's okay.

[timalbers]

If you only want to have it filtered for the slicer visual, you could simply add a rule in the Filter Pane on the right side for this specific visual, to only include dates until today (relative time) or until 15.04. (absolute value)

[suparnababu8]

If date will updated automatically for eaxample 20th Apr 2024. So, it'll be updated automatically?

[timalbers]

As I said, this is up to your configuration. In the filter pane you can choose between something like "is before [an absolute date]" or a relative date span like "is in the last 4 months (inluding/excluding today)". This is all up to you.

[suparnababu8]

It's fine. But I dont want hard code it. It should be dynamic. Need help.

[Joe_Barry]

Hi @suparnababu8 

Did you create you date table by using the Minx(Sales[Date]) and Maxx([Sales[Date]) ? This should only return the dates defined in the Sales Table

CALENDAR (MINX (Sales, [Date]), MAXX (Sales, [Date]))

Thanks

Joe

If you found my answer helpful and it solved your issue, please accept as solution

[suparnababu8]

I tried. But, it's not working. It is showing entire months till DEC-2024.