The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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:
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.
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)
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
13 | |
9 | |
3 | |
3 |