Dynamic user-input date values

[TimQ]

I'm interested in creating a parameter or some other kind of user input element to enable end users to modify the date values a the report data source. The idea is to give users a way to adjust the original date values as new dates (signified by a new start/end date field) in a slicer and base the visuals on those fields so that they can dynamically adjust displayed dates. I played around with parameters and searched for similar solutions but didn't have any luck. Is something like this possible? Report file is here.

Project Num	Start Date	End Date	New Start Date	New End date
P01	1/15/2012	10/1/2012
P02	1/15/2012	10/1/2012
P03	1/15/2012	10/1/2012
P04	4/1/2011	2/28/2013
P05	4/1/2011	4/1/2013
P06	4/1/2011	5/1/2013
P07	9/1/2011	10/1/2013
P08	9/1/2011	10/1/2013
P09	9/1/2011	9/1/2013
P10	9/1/2011	9/1/2013
P11	2/1/2011	10/1/2013
P12	6/1/2011	6/1/2015
P13	4/1/2010	6/1/2014
P14	11/1/2013	10/1/2015
P15	8/1/2014	9/1/2016
P16	11/1/2014	9/1/2016
P17	10/1/2019	10/1/2023
P18	5/1/2022	9/1/2025
P19	7/1/2032	9/1/2035

[MFelix]

Hi @TimQ ,

You want to have the calculations based on a different date for each of the projects?

I can think of a workaround that can have two ways of input. Create a spreadsheet or a sharepoint list with the project numbers and then the users can fill those new dates on that spreasheet / sharepoint list.

The filling of those values can be made directly in the the spreadsheet (saved no onedrive/sharepoint) or using PowerApps visual.

Then you just need to make a connection to that spreadsheet/sharepoint list and update the data.

[TimQ]

@MFelix thanks for the idea. I think this is a solid approach and one that I will test out. I'm really hoping to embed the spreadsheet in the report file itself so the user can enter the data and have teh visual update itself all in one place. PowerApps seems like a promising route. I'm also considering publishing it as an app and embedding the URL to a spreadsheet stored on OneDrive through the app.