Forum Discussion
Paginated Report Date parameter ReadOnly
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.
Hi,
Thanks for the update. Looks like my question in not clear, let me redefine