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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
newpbiuser01
Helper V
Helper V

Setting a default value in a slicer

Hello,

 

I'm trying to set up a report where the slicer always defaults to the maximum value (latest month, year etc.) Based on what I've found so far, I know one way to do it is to create a calculated column where the max value is calculated and defined as "Latest Month" or the "Current Data" and then you select that value in the slicer as the default. Does anyone know of a way to defaulting the slicer selection to the max/latest date without doing a calculated column?

 

Is there any other way where if we have this: 

newpbiuser01_8-1654622946937.png

Instead of this:

newpbiuser01_7-1654622932358.png

Thank you so much for all your help!

1 REPLY 1
speedramps
Super User
Super User

Hi newpbiuser01 

 

Slicers "remember".

So if you build a silcer in Power BI with June ticked and publish it.

The published report will continue to show June when the report is refeshed for July, August, September.

It will stay on June for ever.

Hence the calculated table with "latest month" trick.

You cant build your desired effect using a slicer !

 

I try avoid having months as slicers, and show a tred graph instead with 12 rolling months

and a matric showing the current month if no month is selected

or the current month if a month is selected.

(using HASONEVALUE or ISFILTERED)

 

This works perfectly each time the report is refeshed.

The graph shows the last 12 months.

The matrix shows the current month.

But the user can click any month on the graph to display that month in the matrix.

 

I have helped you.

Please can you help me with kudos by clicking the thumbs up and accept as solution button.

Thank you !

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.