Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Have a date slicer always set on the last month

Hi, I have this slicer: 

SimonePalmas45_0-1676948993154.png

Is there a way to to have the last month dates every time I open the report? for example, if I open it today (21 Feb), I will have dates from 21 Jan to today. 

 

Thank you!

 

3 REPLIES 3
BrianConnelly
Resolver III
Resolver III

What is feeding the slicer, e.g. a date table or the data table?  There is no way for PBI to know what dates to populate, but you can on design.  For example, creating a date parameter table in Power Query that loads with whatever rules you have and then joining on the date dimension or data table.

vicky_
Super User
Super User

Is there any reason you don't want to use the relative date mode in the filter? I don't think there isn't a built in way to automatically change the dates to the previous month's.

Anonymous
Not applicable

Yes, I wanted to be able to select a particular date, another option would be to have both relative and between filters, but they would overlap 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.