Add "Previous Month" AND "All Times" to the Date Hierarchy Dropdown Slicer

[Klausi500]

Hello,
I use the Dropwdown Slicer with the Date Hierarchy.

But I need to add "previous month" and "All Times"

I did manage to have both, but in my case the previous month is excluded in All Times. So When I want to see all Data of the year 2023 and click on it, the data of May is excluded.

Can someone help me with that?

Kind regards
Klausi

[v-shex-msft · Accepted solution]

Hi @Klausi500,

You can create a custom table with all date values and add custom category columns based on conditions.(“All Time” should match with all rows, the “previous month” flag can be calculated and remarked based on the system date or table max date)

Regards,

Xiaoxin Sheng