98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » DYNAMIC DATES
DYNAMIC DATES
Resolved · High Priority · Version 365
Mon 11 Oct 2021, 15:37Delegate 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:13Trainer 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.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Explore Power BI TemplatesTake 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. |
