Customize Slicer Date Picker (Power Query or Java)?

[icassiem]

Good day,

Is there was to customize/dev the date picker slicer?

I have 2 slicers, slicer1 = (date picker) and slicer2 = (YTD, MTD, day ranges)

1.  Slicer2 date range select the dates in Slicer1/Datepicker to changes and selects to the slicer2 range selection

2. I need to add Date From & Date To Labels

3. I can't purchase any visuals, and hoping i can modify somehow

Please Help?

Regards

[Anonymous]

Hi  @icassiem 

Your needs are not clear enough , can you explain the date picker and date range in detail ? Or can you provide a sample for reference ? 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[icassiem]

Hi @Anonymous 
Thank You for assisting

I have a time Intelligence Slicer1 which has date ranges (YTD, Current Month, Current Day, Current Week)

and slicer2 is my calenderdate field which becomes a datepicker on day level.

1. The issue is on slection Slicer1 (daterange month, year, day) the data values change but not the slicer2 date picker date ranges. Its like the slicer1 and datepicker does not pickup/highlight the slicer2 selections 

2. i need to provide labels around the datepicker (date from & date to)

So i am hoping the datepicker could filter to the slicer1 buttons of dateranges, as my senior says it can be done via javascripts but im not sure about this?

Thinking out loud, was to have a 2 text boxes designed to look like a date picker thats shows the date selection of over slicer2 text boxes, but this does not select/highlight slicer1 range on slicer2 datepicker and also the seleted slicer2 date ranges i cant seem to catch

Please help

[icassiem]

Hi,

Please Help, I need the slicer buttons to modify the date picker

I'm not sure from within desktop this can be achieved

Regards

[icassiem]

Good day,

Please any ideas? I have limited time to come up with a solution

Regards

[icassiem]

PlanA

slicer 1 buttons to select ranges and have a custom button that pops up a date picker > not sure how it would allow me to select a date range with 1 button so that i can have text to disply the date ranges selected?

planB

im thinking, slicer1 (ytd, mtd, day) which is an timeintellignece dax script

to change slicer2 datepicker to a dropdown that has an hierarchy containing (YTD, MTD, Day, Custom)

in custum children = all dates available, ytd children = ytd dates, day = current day)

in this time intelligence how would i caliisify the rnages children

please help