Data Analytics
Timespan
explore our new search
​
Default Current Month Slicer in Power BI
Power BI
Nov 14, 2022 12:00 AM

Default Current Month Slicer in Power BI

by HubSite 365 about 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