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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ramesh0103
New Member

custom Slicer with some common options that change my date Slicer

Can we add a custom Slicer with some common options that change my date Slicer?

Common options Like :

  • Last 7 days
  • Last weekend
  • Last 30 days
  • Last month
  • Current month
  • Current week

Please help me on this ?

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @ramesh0103  ,

You can use the Relative date in the Filter:

Filter-Filter type (Relative date)-selection criteria rules

 

For example, display the data in the slicer as last week:

v-yangliu-msft_0-1619591363596.png

Result:

v-yangliu-msft_1-1619591363598.png

For example, display the data in the slicer as last month:

1234.png

Result:

12345.png

This is related content, I hope to help you:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yangliu-msft
Community Support
Community Support

Hi  @ramesh0103  ,

You can use the Relative date in the Filter:

Filter-Filter type (Relative date)-selection criteria rules

 

For example, display the data in the slicer as last week:

v-yangliu-msft_0-1619591363596.png

Result:

v-yangliu-msft_1-1619591363598.png

For example, display the data in the slicer as last month:

1234.png

Result:

12345.png

This is related content, I hope to help you:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MFelix
Super User
Super User

Hi @ramesh0103 

 

Have you tried to change the type of slicer in the header and select the relative slicer?

 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi,

 

Actually i want to use the Date Slicer and custom Slicer both so if user selct from custome slicer or date slicer then report works properly from different slicer.

Do you want them to select one or the other or show both at the same time and work in conjuction?

 

You can add two slicers and one will influence the other one, be aware that this can be a bit confusing for the end user since sometimes the slicing of the information may be contraditory.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi,

 

I am looking for similar type of Custom filer as per the below Video https://www.youtube.com/watch?v=fKygF7VEJnQ

 

which i found but with my option :

  • Last 7 days
  • Last weekend
  • Last 30 days
  • Last month
  • Current month
  • Current week

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.