Nov 14, 2022 12:00 AM

Default Current Month Slicer in Power BI

External YouTube Channel

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