custom Slicer with some common options that change my date Slicer

[ramesh0103]

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 ?

[v-yangliu-msft · Accepted solution]

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:

Result:

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

Result:

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]

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

[ramesh0103]

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.

[MFelix]

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.

[ramesh0103]

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