Relative Date Slicer Working

[Anonymous]

 I connected live data using server so and here my issue in Default relative date slicer the future is data is predicted where i just need the date to be filtered for past and present date data , i even checked to filter the slicer but still there no option to exclude the next option .

in below image atleast i could have able to set limit till today() it would be helpful 

Still didnt solved .If u can suggest anything to solve this Kindly let me know .

Thank you .

@Thennarasu_R 

[Villezekeviking]

You can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!

You can for example set the offset of years between -3 and 0, that will have the last 3 full years including the current one.

-3 to -1 will be the last three years, not including this one.

-1 to 1 would be last year, current year and next year etc.

You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/

[Anonymous]

Thank you .

[lbendlin]

What is the actual problem?  What's the harm when users select a future date?

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[Anonymous]

Thanks I did .

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=740543d0-2b9b-ee11-a81c-000d3a00bef9

[Anonymous]

The thing is there is no requirement of future data filtering in my report , and even as per my understanding the future data is on prediction basis , which might not be accurate one .

Main reason I just want to filter data using time period like year,month,week,day wise according to the user's wish 

Ex: last 5 days 

present day/week/month

overall year

(these filtering will help to analyse very specifically) .

Can you suggest any approach ??

[lbendlin]

My suggestion would be to ignore this part.