Forum Discussion
User Selectable Parameters for a Date Range
Hey all,
Is there a way to make User Selectable (Report Level) dates that are passed as parameters to a query?
From an SAP BW, we are using a BEx query as a datsource. That query needs 2 parameters: a start and end date (date interval):
Although these parameter variables were set up to be dynamic, but automatically calculated, it is now being asked to make the Start Date and End Date user selectable. I can't wrap my head around how to make a Report level slicer that passes it's value to this parameter. Any suggestions?
jribs you can use parameters but these will not be user selectable.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
jribs you can use parameters but these will not be user selectable.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
