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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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