Default Current Year, Quarter and Month in one slicer

[Prabha45]

Hi All,

I have a single slicer with Year, quarter and month hierarchy in the image below. I need to show current month in this slicer by default. How can I achieve this ? TIA

[TomMartens]

Hey @Prabha45 ,

because the current slicer does not support the concept of a default value, implementing something similar to a default value is not that simple.

You have to create a new column in your calendar/date table flagging the rows that  are in the current month, quarter, year with the value "current" and all the other rows with "not current".

Then you can create a second slicer with the values. If a user wants to have access to non-current values he can remove the current  selecteion.

Of course this requires that the calendar/date table will be refreshed every day.

Hopefully, this provides some ideas on how to tackle this challenge.

Regards,

Tom