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 Slic...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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'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