Forum Discussion

sshiny's avatar
sshiny
Icon for Helper II rankHelper II
4 years ago

Date slicer

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 ...
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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-30/m-p/1284966#M561629

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