Slicer filters

[Syndicate_Admin]

Good afternoon, I need to create a slicer filter in whatever the last month of the year you're running, and change automatically as time go by(from/to).

Codial greetings.

[aj1973 · Accepted solution]

Hi @Syndicate_Admin 

You can not use a measure into a slicer. What you can do is Use(existant) or add a column dates and use it as a slicer like this

[Anonymous · Accepted solution]

Hi  @Syndicate_Admin  ,

You can choose After in Slice. The end date will change with time. For example, today is April 28, and tomorrow, the end date will change to April 29.

In the Relative Date in the Filter, select the time and limit the date to the previous 1 week or the previous 1 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

https://radacad.com/from-and-to-date-slicers-in-power-bi-filtering-based-on-two-fields

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.

[aj1973 · Accepted solution]

Hi @Syndicate_Admin 

You can not use a measure into a slicer. What you can do is Use(existant) or add a column dates and use it as a slicer like this