Forum Discussion

TheInvoker's avatar
TheInvoker
Frequent Visitor
4 years ago
Solved

How to setup a datetimezone picker for a datetimezone parameter?

In my query editor, I have 2 parameters (start, end) which are types datetimezone.

 

I want to expose 2 datetimezone pickers to the user so they can pick the 2 dates and let that update the graph.

 

Is this possible to do?

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  TheInvoker @

    I suggest you to use this customer visual "Smart filter by OKVIz".

    You can enter the date format in power bi in the checkbox that appears, and the checkbox below will automatically display the date format that matches your input.

    https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?src=office&tab=Overview

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    How to setup a datetimezone picker for a datetimezone parameter.pbix490 KB

4 Replies

  • TheInvoker's avatar
    TheInvoker
    Frequent Visitor

    I saw the tutorial for slicers and parameter binding, but the problem is that the user is required to pick from a dropdown of limited values. I want the user to be able to enter any arbitrary datetime like how a datetimepicker looks like in google chrome browser using <input type="datetime"/>.

     

    I can also change it to string value instead of datetimezone. If I do a string format, is there a way the user can type a text and let that bind to the parameter?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  TheInvoker @

    I suggest you to use this customer visual "Smart filter by OKVIz".

    You can enter the date format in power bi in the checkbox that appears, and the checkbox below will automatically display the date format that matches your input.

    https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?src=office&tab=Overview

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    How to setup a datetimezone picker for a datetimezone parameter.pbix490 KB
    • TheInvoker's avatar
      TheInvoker
      Frequent Visitor

      Will it always have the current date in it? And can I pick times as well?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  TheInvoker,

    The current date will always be included, and by clicking the button with the yellow dot, you can select the time.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.