Date slicer

[sshiny]

Hi,

I currently have a date slicer filtered to the last 3 months date range using relative date. Is there a way where by default the report will load the data between the 3 months range and will the date picker be enabled to select previous months data as well?

As of now,

I need the highlighted data range to be enabled.

[amitchandak]

@sshiny . no.

You can create a column like this in your table and save on  that

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) <= eomonth(Today(),-1) && eomonth([Date],0) >= eomonth(Today(),-3),"Last 3 month Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

or refer

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI