Forum Discussion
Default Filter when page loads
For example say I have a date filter (created using a slicer) and a bargraph in which the x-axis is set for the date. So what I need is both of this visuals to be filter for the last 3 months when th...
Anonymous , On option, is relative date slicer : https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Other is : Create a column like this in date table and use as filter
Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),0) && eomonth([Date],0) >= eomonth(Today(),-2),"Last 3 Month" ,
Format([Date],"MMM-YYYY")
)
Anonymous , On option, is relative date slicer : https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Other is : Create a column like this in date table and use as filter
Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),0) && eomonth([Date],0) >= eomonth(Today(),-2),"Last 3 Month" ,
Format([Date],"MMM-YYYY")
)