Paginated Report Date parameter ReadOnly

[nagaraj]

Hi,

 I have a scenario, where in I have below 3 scenarios and 2 Parameters

 Parameters"

 -----------------

 Scenario : Live,

                 2024 Q1

                 2024 Q2

                 History

 AsofDate : If user selects Live (in the above parameter) -- this field should display today date and user should not select any other date..

2. If user selects 2024 Q1, this field should display 3/31/2024 and user should not select any other date

3.  If user selects 2024 Q2, this field should display 6/30/2024 and user should not select any other date

4.  If user selects Hisotry (above)..user should see Calendar picker and he can select any date in the past..

Can anyone help how to achieve these

For the first 3 scenarios , the dates are reading from database

[Anonymous]

Hi, @nagaraj 

I am glad to help you.

Based on your description, I think your requirement is as follows: you want to create four parameters to filter the corresponding data, but your parameters do not exist in the data source.

Unfortunately, your idea is possible when making a normal report in Power BI Desktop. You can do this by splitting the string into valid date/time types and filtering the date based on this data.

But for Power BI Report Builder, the limitations of the functions in it are very high and there is no way to directly realize such an intelligent requirement. Moreover, as you mentioned, the parameters you are filtering on do not exist in the data source, which is difficult to realize .

If you want to filter your dataset by parameter, you can refer to the last reply of this issue below:

Solved: Power BI Report Builder- Query Designer not showin... - Microsoft Fabric Community

in this method

It is possible to interact with the parameters in the paging report, and then on top of this, using SQL Server as an example, you can add other SQL filtering statements to achieve the current requirements.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagaraj]

Hi,

 Thanks for the update. Looks like my question in not clear, let me redefine