Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
2 years ago

Customize Slicer Date Picker (Power Query or Java)?

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

Need Help

5 Replies

Replies have been turned off for this discussion
  • icassiem's avatar
    icassiem
    Post Prodigy
    2 years ago

    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's avatar
      icassiem
      Post Prodigy
      2 years ago

      Good day,

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

      Regards

      • icassiem's avatar
        icassiem
        Post Prodigy
        2 years ago

        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 

         

    • icassiem's avatar
      icassiem
      Post Prodigy
      2 years ago

      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