add button for more recent dates for slicer

[nerdyplayer]

Trying to make a slicer by using a new measure where it defaults to showing the last 6 months of data, and then give selection for the all the dates.

IE
select all

[x]last 6 months

[] 2023
[] 2022

[]2021

ty

[Nayan_surya]

Hi @nerdyplayer ,

Believe this is the most common request and native Power BI date Slicer does not have it built in. What I ended up doing is getting a custom visual called Date Picker by Powerviz. It has all these presets built in to the system with no need to use Dax or anything.

I think you should check them out.

Here is a link if you want to check this visual - https://appsource.microsoft.com/en-us/product/powerbivisuals/truvizinc1674781244292.date-picker-by-p...  (I believe they offer a free version too)

[ChiragGarg2512]

@nerdyplayer , That could work or there can be a column that works like if year is 2023 and month is greater than or equal to month(today() -6) return "last 6 months" and else returns year number in text format.

[ChiragGarg2512]

@nerdyplayer , slicer cannot be made using a measure. 

[nerdyplayer]

okay, if i were to make a table, would i make a new column for like today()-180, and use that as a sort function on the slicer?