How to Set Default Slicer Value in Power BI?

Do you know how to set default slicer value in Power BI? No issues!

In this tutorial, I will explain how to set the default slicer value selection in Power BI and how to set the default slicer for the current month in Power BI.

Also, I will guide you on how to set the default slicer to the current date and time in Power BI with different examples.

How to Set Default Slicer Value in Power BI

Setting a default slicer value in Power BI means choosing a predefined filter option that automatically appears when you open a report in Power BI.

How to Set Default Slicer Selection in Power BI

Here, I have a SharePoint list (Employee Leave List) that I used for this Power BI Report.

ColumnsData Types
EmployeeIDNumber
EmployeeNameSingle line of text
LeaveTypeSingle line of text
StartDateDate and time
EndDateDate and time
DurationNumber
StatusSingle line of text
power bi slicer default value

I will show you how to set the default value in the Power BI slicer.

1. Open Power BI Desktop and load data using the Get data option. Then, we can see the data set in the Data Panel.

power bi set default slicer value

2. Under the Visualizations panel, click the Slicer visual. Then, drag and drop the StartDate into the Slicer Field.

Slicer default value in Power BI

3. Then go to Format your visual pane -> Click Visual -> Click Slicer settings -> select Selection -> turn on Single select.

Power BI default slicer value

4. Now, choose an item from the dropdown of the slicer. It will appear as the default value on that visual, as shown in the screenshot below:

Power BI Slicer default value date and time

This way, you can set a default date for Power BI Slicer.

Set Default Slicer Current Month in Power BI

Now we see how to show a current month as a default value in Power BI Slicer.

1. Open the Power BI Desktop and load data using the Get data option. Then, under the Home tab, click Transform data.

Set Default Slicer Value to Current Month in Power BI

2. Then in the Power query editor page, go to Add column -> Custom column.

A Custom Column page will appear. We have to give the name and put the formula below, then click OK:

Date.MonthName( DateTime.LocalNow() )   
Power BI Slicer default value current month

3. Now, you can see that one column (CurrentMonth) has been added. In my case, the row shows ‘December,’ corresponding to my local system date. Check the screenshot below.

Current month default selection in Slicers

4. Click on the Home tab -> select Close & Apply. Then, in the Visualizations panel, click on ‘Slicer’ and drag ‘CurrentMonth’ into the slicer.

Slicer to select current month as default

In this way, you can set the current month as the default value in a Power BI Slicer.

Set Default Slicer Current Date and time in Power BI

Now, let’s explore how to set the default slicer to the current date and time in Power BI

1. Open the report View under the Home tab ->click Transform Data

Set Default Slicer Value to Date and time in Power BI

2. Then in the Power query editor page, go to Add column -> Custom column.

A Custom Column page will appear. We have to give the name and put the formula below, then click OK:

DateTime.LocalNow()
power bi slicer default to most recent date

Now you see a new column(i.e., Current Date & Time) added to the data model.

3. Click on the Home tab -> select Close & Apply. Then, click ‘Slicer’ in the Visualizations panel and drag the Current Date & Time into the slicer.

How to Set Default Slicer selection to Current Date and Time.

4. Go to Format your visual  -> click Visual -> click Slicer settings -> click Selection -> turn on Single select.

Set Slicer to Date and Time in Power BI

You can do Power BI Slicer default value Current Date time.

Conclusion

I hope you found this article helpful for Setting the default slicer selection in Power BI.

In this article, we covered how to set the default slicer value in Power BI and show a current month as a default value in the Power BI Slicer.

Also, we covered how to set the default slicer to the current date and time in Power BI.

Moreover, you may like some more Power BI tutorials: