Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Light_bringer
Regular Visitor

How to set Default value in a power bi slicer ?

Lets say there is a slicer in the report which shows list of month. If open the report freshly i should see the current month by defalut.
Like in the picture

Light_bringer_0-1686315847100.png

 

1 REPLY 1
lbendlin
Super User
Super User

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors