Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
kmei001
Frequent Visitor

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 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community 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.

View solution in original post

1 REPLY 1
v-janeyg-msft
Community Support
Community 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.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors