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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ejp001
New Member

Cascade Parameter in powerbuilder

I have a couple of Parameters that does not refreshing after the first time using. in other words, it is a date range parameter, that update a startmonth and EndMonth parametes, but If I choose antoher option from Date range parameters the other ones do not change. the Startmonth and endmonth it is a query with a @daterange parameter.

1 REPLY 1
jaweher899
Impactful Individual
Impactful Individual

It seems like the issue you're facing is with the dynamic update of the parameters. To resolve this issue, you can try the following:

  1. Re-run the query when the date range parameter changes. You can achieve this by setting the "Refresh Automatically" option to "On Change" in the data source properties.

  2. Use a DAX expression to dynamically update the start month and end month parameters. You can use the following expression in the StartMonth and EndMonth parameters:

StartMonth:= MIN(@daterange) EndMonth:= MAX(@daterange)

  1. You can also try to modify the queries that use the StartMonth and EndMonth parameters to include a filter based on the date range parameter, like this:

Filter(MyTable, [DateColumn] >= MIN(@daterange) && [DateColumn] <= MAX(@daterange))

This way, when the date range parameter changes, the filtered data in the StartMonth and EndMonth parameters will also be updated.

I hope this helps you resolve the issue you're facing. Let me know if you need further assistance.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.