Power BI custom date selection- selected date, one day prior and one day after of selected date

[01UmaManoharan]

Hi All,

Need your help on power BI reporting scenario. I have a table visual which has ID,date and slicer with date. for an Example, if i pick Nov 2 2023 in date slicer, it should give me dates and IDs of Nov1, Nov2, Nov3 of the year 2023 thats is selected date, one day before and ane day after of selected date.

woult it be possible when i have data in my Table visual.

Thank you

[01UmaManoharan]

Thanks a lot for the assistance. I'm able to get the same when i just use ID and date in my table visual. However i will have to show various information from single table input. its all just drag and drop. The M1 measure here is used to get the dates logic I beleive. but the same M1 logic is not working if i pull mutiple columns in my table visual. Your help is much appreciated. it would be great if you provide some ideas. Thanks again for your efforts

[Ahmedx]

what is needed, why does the measure not work? show an example

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.