DAX Fridays #155: How to set default value of a slicer in Power BI

In today's video, I will show you how to set the default value of a slicer in Power Bi using some simple DAX.


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[reynaldomalave]

Thanks for this and all the videos.You are a life saver. Keep on the good work and be safe!

[Sanj]

That was awesome. One of my colleagues was looking for this few days back and we were not aware of how to do this.
Thanks a ton for this wonderful video. Now we can set the default value to a slicer.

[CCHSmathematics]

So creative! That is awesome. Thanks for sharing Ruth!

[rauljimenez]

Very useful information and overall workflow that can be used in many situations!!

[TravisUrban]

🤩Thank you SO much!! Brief, to the point, and functional. I have wasted two days on the intrawebs trying to find an answer on this extremely basic question, and this solution is the first I've run across that is adaptable, works, and is not a complete hack job.

[mshparber]

Haven’t watched yet, but this sounds as a dream come true!!!

[davealexander]

Very handy...with one problem. The displayed values are now inconsistent with the slicer selection. In this example you're displaying EUR conversion, but the slicer itself does not indicated that. My as-yet unsolved problem is to SET the SELECTEDVALUE, and not just get it. Then the values displayed will as I desire automatically, because that's what the slicer is showing.

[ayobamiologun]

Very cool and interesting. Thanks a lot, Ruth.

[alexssandrodamiao]

Hello, excellent video. Is it possible to format the coins? If selected EUR is formatted for the euro currency, if selected USD formats for dollar

[arklur]

The title is kinda misleading. With that title I would assume to see how can I set a default value for a slicer, visually, and not making a measure which ensures that it will calculate something only with 1 value, so even if there is nothing selected or there are multiple items are selected, it will still work, won't show non-sense results.


On a side note, it still bothers me it's not possible to set a slicer's default value dynamically :(. I'm aware of the workarounds ("calculated column for 'current month?' Yes : No" then filter on it), but users often want to **see** the selected value (e.g. current month by it's name!). Exactly what SSRS is capable of with it's "Default value" property for parameters. Not sure why it's not a priority for Microsoft, many of our customers wanted to see this and wasn't really happy that it's not possible :/.

[gamerleon]

Hi Ruth,
First of all thanks for your videos, i entered Power BI world an year back and got to learn many things from your videos.

Regarding using default in slicers Is there a way to set a default date range to an in-between date slicer? For example if I want to land on the report, the date slicer should be selected for Last 30 days or so by default, then later I can change the date accordingly. I know we can use relative date slicer for this. But can we achieve this using only in-between slicer as well? Is there a video available on this topic, if no can you please make one?

Have a good day.
Best Regards,
Pratik

[anjanathakur]

@Curbal : I have a situation where I want to Set slicer value selected to a default value, but show other values also in dropdown on that slicer based on selection of another slicer

[poojachoudhury]

I loved the trick you have shown.. Just stuck in one small area.. I need to select multiple option as default...in your example what if I want to select both EUR and USD as default???

[Onix]

Yes, but in a usability perspective, when the default value is "selected", in the case "EUR" should be shown as checked in the slicer in order to provide feedback to the user of what's the default value, it's possible to do that?

[AbhiChoudary]

Very Useful! How to set default select slicer itself? Let’s say I have 100 currency codes in Slicer but want display USD as default section in slicer?

[granand]

Hey Ruth, Is there a video to extend this to select default financial years to say 2 years from current date ?

[JenMayB]

Thank you so much. Is it possible to do that with row-level security? For example, I want the default slicer selection to be the row level security of the user. The values are from the same table.

[csrajaraman]

Is there a way to filter the slicer itself..? I have too many values on my page so I would have to create a measure for each of them.

[varun]

Where u r using the tranexchangerate measure (in which visual)' time 52 sec'. can anyone explain ?

[revenge]

thanks, how do I do this for a line chart?