Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Parameter Showing up list

Hi Community,   I am using Power BI Report builder and I have to create one start date and end date parameter which should be < Today(). I have created two different Dataset each for start Date an...
Date Parameter
Report Builder Date format
Report Builders
d_gosbell's avatar
d_gosbell
Super User
5 years ago
Anonymous wrote:

What is the workaround to Provide Date parameters where use can select dates prior to today only?

 

Unfortunately there is no work around. If you set a list of available values they are always displayed as a list. You only get a calendar picker if you set the parameter as a datetime without a list of available values and if you do that there is no way to block invalid values. The only workaround is to block these in your query so that the report returns no data and then maybe configure a message to display if there are no records in the dataset.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Is microsoft working on this issue, can i expect this in upcoming Report Builder releases? or do we i have to submit ideas for this?

    Thanks,
    pravin

    • d_gosbell's avatar
      d_gosbell
      Super User
      5 years ago
      Anonymous wrote:

      Is microsoft working on this issue, can i expect this in upcoming Report Builder releases? 

      No idea, but I have not seen anything like this mentioned in any of the public road maps.

       

      Anonymous wrote:

       or do we i have to submit ideas for this?

      That's probably a good idea.