Forum Discussion

kmei001's avatar
kmei001
Frequent Visitor
4 years ago
Solved

Restricting parameter selection in paginated reports

I've recently started working with paginated reports and learned that I can make something a parameter by checking the little square in the query designer wizard. I am making something where a drop down of dates is the parameter, but I can't seem to find a way to restrict the dates that appear in the parameter. 

 

For example if my data set had all the days in Jan 2021 and Feb 2021, but I only wanted days from Feb 2021 to appear, how would I go about doing this? 

1 Reply

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, kmei001 

     

    The parameter can be used to filter the date. 

    You can create a date pickers to filter data by two selections in the following way:

    Using Date Pickers in Power BI Report Builder (coeo.com)

     

    Best Regards,

    Community Support Team _Janey

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