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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
michelp
Frequent Visitor

Date slicer preset

Hi,

 

I have a slicer in my report that is used to conveniently filter the data in my report. However, I want to add some presets:

- This month

- Last month

- This year

- Last year

 

etc

 

Is this possible in some way?

 

9Vq4mdu

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@michelp ,

 

Change your date slicer Range format to Relative and change the drop down for Last 1 year,Month etc.

 

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

4 REPLIES 4
Nayan_surya
Frequent Visitor

Hi @Tahreem24 ,

 

If you want to avoid using Dax and still want to add these presets to your date slicer, I believe custom visuals are a way to go. I've recently come across a visual named Date Picker By Powerviz. It has all the presets you're looking for all it needs is the date from your data rest it calculates by itself.

 

Nayan_surya_0-1702625494209.png

Here is a link if you want to check this visual - https://shorturl.at/pAM18 (I believe they offer a free version too)

Tahreem24
Super User
Super User

@michelp ,

 

Change your date slicer Range format to Relative and change the drop down for Last 1 year,Month etc.

 

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Thanks!

Tahreem24
Super User
Super User

@michelp 

 

Refer below screen shot.

 

Capture.JPG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors