topic Re: Date slicer with default date range like 12 month and user can also select own date range in DAX Commands and Tips

Date slicer with default date range like 12 month and user can also select own date range

Puja_Kumari25 — Sat, 24 Aug 2024 15:25:41 GMT

Hi,

We need to implement a Date slicer in which by default date range is selected like 18 months from today and the user can also choose the date range according to their need. The date slicer has the between setting.

When the report is opened, by default 18 months of data will be displayed and the user can use the date slicer to select data according to their requirement. data will be shown with the updated date range value of the date slicer.

I would greatly appreciate your help.

Re: Date slicer with default date range like 12 month and user can also select own date range

ahadkarimi — Sat, 24 Aug 2024 15:35:22 GMT

Hi Puja_Kumari25, give this a try, and if you encounter any issues, let me know.
create a date table:

DateTable = ADDCOLUMNS ( CALENDAR (DATE(2010,1,1), DATE(2030,12,31)), "Year", YEAR([Date]), "Month", MONTH([Date]), "MonthName", FORMAT([Date], "MMMM"), "Quarter", QUARTER([Date]), "YearMonth", FORMAT([Date], "YYYY-MM") )

Measure:

IsInDefaultDateRange = IF ( 'DateTable'[Date] >= EDATE(TODAY(), -18) && 'DateTable'[Date] <= TODAY(), 1, 0 )

Did I answer your question? If so, please mark my post as the solution!✔️
Your Kudos are much appreciated! Proud to be a Responsive Resident!

Re: Date slicer with default date range like 12 month and user can also select own date range

Anonymous — Mon, 26 Aug 2024 02:58:37 GMT

Hi Puja_Kumari25 ,

Here you may need to use a custom visual called a pre-selected slicer:

You'll also need a bookmark that clears the date pre-screening and binds it to the button:

I made a simple demo, hope it helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Date slicer with default date range like 12 month and user can also select own date range

Puja_Kumari25 — Mon, 26 Aug 2024 06:30:37 GMT

Hi Cgao, I am implementing this solution but I found once more that the challenge date slice is not filtering based on the pickup slicer. How to resolve it.

Re: Date slicer with default date range like 12 month and user can also select own date range

Puja_Kumari25 — Mon, 26 Aug 2024 06:47:55 GMT

Resolved this by advance option of sync slicer

Re: Date slicer with default date range like 12 month and user can also select own date range

Anonymous — Mon, 26 Aug 2024 06:51:23 GMT

Hi Puja_Kumari25 ，

1. When first turned on, the slicer will use the pre-selected slicer settings (from today to the next 18 months)

2. When users need to change the between slicer, they need to clear the pre-selected slicer with a click of the button before proceeding to the next step.

At this point the dates in the between slicer will change to all dates:

Best Regards,
Gao
Community Support Team

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Date slicer with default date range like 12 month and user can also select own date range

Puja_Kumari25 — Mon, 26 Aug 2024 06:57:08 GMT

Our issue is that the date slicer is not syncing with the pre-selected slicer. It shows the min and max days form calender.

Re: Date slicer with default date range like 12 month and user can also select own date range

Anonymous — Mon, 26 Aug 2024 07:15:23 GMT

Hi Puja_Kumari25 ，

Got it. Please check the interaction of the preselect slicer with other visuals to make sure it filters to other visuals.

Best Regards,
Gao
Community Support Team

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Date slicer with default date range like 12 month and user can also select own date range

Puja_Kumari25 — Mon, 26 Aug 2024 11:38:55 GMT

Hi,

The solution is working,

Thanks for your help and support.