Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to Solution.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
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.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook