Default Current Month Slicer in Power BI
Power BI
14. Nov 2022 00:00

Default Current Month Slicer in Power BI

von HubSite 365 über Wyn Hopkins [MVP]

Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers

Data AnalyticsPower BILearning Selection

How to default to the current month

There's no built-in way to default the slicer selection to the current month. But 2 extra Power Query columns in your Calendar Table may solve the problem

In this Video

00:00 Intro

00:20 See the end result

01:12 How to adjust the Power Query Calendar

02:59 Question: What do you mean by "Current"

04:20 Sort By

04:40 A couple of things to be aware of