March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi Everyone!
I am hoping to get some help with a visual I'm trying to make. The page will have a table which tells the user what tasks they have to do and by when, based on the date they start.
I want to enable the user to be able to input the date they start into the dash through a slicer and the data in the table changes accordingly, I know I can add a formula to make the date feild dynamic i.e dateadd([parameterName],-2,"days, but I wondered if it's possible to have the user change the date from the front end?
Below is an example where they can change the start date box and the following changes too.
Yes this is similar to what I've been doing. Only thing is that the [Date] feild is not dynamic, there will have to be data for this, i.e I will have to put the date from today until 10 years time in order for the dynamic feild to work wont I?
Hi @Anonymous ,
Whether the advice given by @amitchandak has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
@Anonymous , You can use slicer and choose list or range slicer. Not very clear what is challenge
My challenge is the due date must be dynamic and the start date is not in the data, it would almost be perhaps an input parameter?
@Anonymous , Create an independent date table, and use that in slicer
then you can have due date like
due date +3 days =
maxx(allselected('Date'), 'Date'[Date]) +3
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
146 | |
97 | |
79 | |
69 |