cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
purralburu
Advocate I
Advocate I

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

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

Give your votes!! 😉

amitchandak
Super User
Super User

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

 

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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || Learn 50+ Power Query List Functions
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.