Advanced Date Picker

RBI — Tue, 07 Aug 2018 18:54:26 GMT

I am using Power BI Report Server 2017 and am a bit disappointed in the data picker for the SSRS/paginated reports. Most modern date pickers allow you to navigate dates more quickly by clicking on the month and the calendar view will dynamically change. An example can be found here: https://demos.telerik.com/kendo-ui/datepicker/index . Are there any plans to introduce a more advanced datepicker or is there a setting in the config that I can use to turn on more datepicker features?

Re: Advanced Date Picker

mgmeyer — Tue, 07 Aug 2018 21:04:59 GMT

Thanks RBI for the suggestion however at the moment there is no way for the data picker to be overriden in the server; however at some point we do plan to update this. I would suggest that you post a request/idea here so this can be voted on by the community.

Re: Advanced Date Picker

andres777 — Tue, 26 May 2020 22:09:00 GMT

I really do not like some people's solution of using a date range control and covering up one of the dates to make it look like it works fine.

We had many users pushing us (BI Analyts) to come up with a more professional solution that works well and looks good.

So I had to write my own custom Visual DatePicker (and go through the steep learning curve to learn all: Node Js, Ms Code, JavaScript, XML Parameters, Syncfusion parameters, Power BI compilation process, Sync calendars, etc) it took me around 2 months or more to come up with something end users would love and accept to use.

Since I didn't want to reinvent the wheel, I searched and searched all over to find some source code I could re-use inside Power BI environment. Because Power BI acts and works like a website, I thought I should look for javascript components. So I found and purchased the SyncFusion Essential JS 2 libraries, just to use one control, the datePicker, the other 59 controls are available for us to use at another time if we want...

A sample of how their calendar datepicker works in on their demo page... Link

Disclaimer : I don't work for SyncFusion or get paid by them to say these comments, I'm just a frustrated user that wanted a professional solution inside Power BI, which according to most users, should be out by now.

Clicking on a Day will select that date, clicking on "May 2020" will allow you to select the Month, and further down, clicking on the "2020" will allow you to select the Year. Very simple, elegant and professional.

picking a day ;

picking a Month

picking a Year :

This is what mine looks inside Power BI...

Users click on the Calendar Icon, and I bring the bookmark Page that contains the

DatePicker Control. Allowing them to select ONE, single date.

(I removed some labels from the grid, to protect the inocent :)...)

Hope this helps some people...

Andres

topic Re: Advanced Date Picker in Report Server

Advanced Date Picker

Re: Advanced Date Picker

Re: Advanced Date Picker