DYNAMIC DATES

Resolved · High Priority · Version 365

Mon 11 Oct 2021, 15:37 Delegate Piotr said...

Piotr has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course

DYNAMIC DATES

Hello,

I would like to ask you if there is any way to create a formula in DAX, so the slicers for months can automatically be changed based on current month and rolling itself, without necessity to change them manually?

Kind Regards,

Piotr Jedrzejczyk

Mon 11 Oct 2021, 19:13 Trainer Jens said...

RE: DYNAMIC DATES

Hi Piotr,

Thank you for the forum question.

I believe that I have found an article with the steps you will need to do (link below)

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

Please let me know if it doesn't make sense.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 18 Oct 2021: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Explore Power BI Templates

Take advantage of Power BI templates to streamline report creation. Templates allow you to reuse custom layouts, themes, and configurations across multiple reports. Create templates for consistent branding or industry-specific reporting standards, saving time and maintaining a cohesive look across your organization's reports.

View all Power BI hints and tips