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")
)
v-cazheng-msft
Community Support
Community SupportHi, Anonymous
You can refer Display Last N Months& Selected Month using Single Date Dimension in Power BI.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.