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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
newpbiuser01
Helper IV
Helper IV

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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