Reply
purralburu
Advocate I
Advocate I
Partially syndicated - Outbound

Select default value on a slicer

Hello Everyone.

 

We're trying to find a way to do something that apparently seems easy, but the truth is that we are not being able to solve it.

 

The main goal is to have a Slicer of months, which, everytime the report is opened, the value is fixed in the current month, meaning the most recent month with data available (as seen in the image).

purralburu_1-1662539299719.png

 

 

We need to see it this way, since we can allow the user to select any other month (having the other months available in the Slicer as well).

 

We've come across several options and the most repetitive one we found is the one to create a "CurrentMonth" column in Text format, and in the Slicer the CurrentMonth Value remains within the list of months and not the value of the month.

 

And another option is to use the TimeLine Slicer, which is not possible since the client don't want it.

 

Is there any other way to do this, any suggestions, or is not possible to do at all?

 

Thank you all in advance.

 

Greetings.

2 REPLIES 2
purralburu
Advocate I
Advocate I

Syndicated - Outbound

Here is the original idea: Microsoft Idea (powerbi.com)

Give your votes!! 😉

amitchandak
Super User
Super User

Syndicated - Outbound

@purralburu , As of now default value and timeline slicer are the only options. 

 

You can log an idea https://ideas.powerbi.com/ideas/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)