Need Help to Create Default Hierarchical Slicer.

[katkar]

Hello,
I have a one urgent and important requirment about default slicer.
in my dashboard i have a hierarchical slicer for Year then month and then last Week end date all in one slicer.
so to automate i have created Dafault last Week end .and its working fine so far.
but problem arises when month changes. so when month changes from march to april that Default last Week end slicer need to change automatically.
not depend on month changes or year changes.

So basically I need  one hierarchical Slicer for year , month and last Week end. where it changes automatically when year changes month changes and week changes.
So please help me with the solution.
Thank you In advance.
Here is the Screenshot of slicer.

[Anonymous]

Hi @katkar 

My sample:

from 2024/1/1 to 2024/3/12

You can create a calculated column as follows.

Column = IF([Date] >= (MAX([Date]) - 7), "Prior week", FORMAT([Date], "dd-mm-yy"))

 

After you add new data.

You need to click Refresh.

Best Regards,
Yulia Xu

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

[katkar]

Yes As you suggested i have already Created Prior Week as Custom SLicer but when month changes it stops in previous month and i need to select to the new month so requirement here is I want to select That prior Week in Current month Automaticaly. without selecting manually.