Power BI - How to Set a Default Slicer Value 

A solid technique for sure. However, what a lot of people are looking for is a way to change the actual slicer selection upon refresh. For example, imagine a model is updated weekly, and there is a slicer set to filter on the latest week (i.e. "week ending mm/dd/yyyy"). When the report is updated, the slicer for week does not "change itself" to the newest week; users are still required to make that change. Thanks for all your contributions to the community!

What a Great Video..Amazing DAX logics. Thanks a lot!!

This measure here is a pure gold, thanks a lot! Can be used for any period, week, year with a little tweak For my task - get variable filter for each month of 3 years i only need to + YEAR - YEAR * 12 Var. filter = IF( MONTH('Date'[Date]) = MONTH(TODAY()) && YEAR('Date'[Date]) = YEAR(TODAY()), 0, MONTH(TODAY()) - MONTH('Date'[Date]) + ((YEAR(TODAY()) - YEAR('Date'[Date])) * 12) )

I couldn't get the second IF statement to work with dates (results just showed blank), but it worked once I replaced it with a Filter expression. Either way, I've been looking for this solution for a while now. Thanks so much for sharing!

Great! I had a similar problem, and thanks to you my problem is solved. Thanks a lot! ;)

Great solution! Thank you so much!

Thanks. Great video tutorial.

Life saver....thanks!

Great video!

Indeed a cool trick !!!

Inspiring video, thanks .. I found it when i was looking for a solution for my case, which I have an event calendar table and want to show one event (let's say event A) with each other single events, so it is more like event A should always be in the calendar with the other event(s) which is (are) selected by the user. I appreciate any suggestion/help. Thanks :)

This works great IF you've got only a few different visuals... But Is there a way to set a default slicer for the entire report? (not just specific visuals) - I've got dashboards with literally 40-50 visuals spanning a few pages.

Nice!

How did you create the month's tabs?

do you ahve a video how to make that exact slicer ? Thx

what if the column we want defaultselection for is not a date column rather what if it's a text column. If column has value like '2020-21'. Is it possible to do it for text column??

This is indeed cool; however, what most of us wish is to **visually** have the slicer change to a default value. With this trick, it can be confusing for the user since they don't know the actual value filtered in the visualizations.

This does not "set a default slicer value"; this only filters data based on slicer (or simulate click on "Current Month" when nothing is selected), but slicer is not setup automatically based on some data. I'm looking for solution: when new day is processed in DWH, I need slicer to be automatically switched for that new date.

How do i do it for the days in a month? How do i write the dax for it? Sorry. Pretty new to this.

Hello great video. I tried working on this but the date range is giving me wrong "Month(s) ago" values since there are data from last year. How do I deal with this?

I have data from Jan/01/2021 to up to current date and also future dates in my date table. I want to show the current month as the default Month in slicer dynamically ( whenever we are getting the latest data)

how to count how many itmes selected in slicer in power Bi ?

Thanks for the video. But I am confused: if we selected all or none, the logic goes to the second IF, how can the expression SelectedValue(data[daterange]) = "Current Month" be true, it should return Blank(). Anyone could help?

What about for multirow cards?

Hi little confused on second if part...when nothing is selected how does selectedvalue DAX return "Current month"

if i'm not mistaken, this just "defaults" to sum certain rows; it doesn't really filter your data unless you've already kind of pivoted everything into a single table and it's all numerical data. otherwise, it's just a ginned-up sumif expression which makes it useless for folks trying to set a default filter on appended tables/datasets based on source.name. could be mistaken tho.

Can you just put daterange in the page filter and tick select all for a card?

Good video ... Remembered me of my old Excel days, but it seems you are missing the point. What people in all those forums mean is: click on a slicer value, hit save, exit and every time the dashboard is opened, this saved selection is there! That is the stuff which drives people crazy, not that you cannot prefilter (which is basically what you are doing here) the data which is affected by those slicers! In 2021 power bi still cannot do the simplest things as storing column widths (permanently no matter of which slicer...), Store default drop-down selection, get proper formatting etc. Etc.

How did you get the Amount column?

I get the result as Blank, am I missing something, please help

Hello, is there a similar workaround to default a slicer based on user log in? The RLS settings work fine, but when the dashboard is accessed the slicers are not automatically selected. What I was hoping to do is: If user 1 logs in, this user should automatically see his or her own data and the slicer is automatically selected. But based on user 1’s role, he/she should still be able to see other options in the slicers. What I am having issue now is when user 1 logs in, this user can see the options relevant to him/her but the slicer is not automatically selected by default so the visuals still show blank. Appreciate your advice. Thanks in advance!

👍👍👍

Hi! What if I wanted to set 2 slicers as a default? Let's say Región and Currency. Is it posible to add a "&&" to the SELECTED VALUE filter?

Hi I am unable add date range column using mention function can you please help me

It appears your calculation returns negative "Months Ago" when calculating months from different years

Good one! but it should be like if all filters are selected then it should show all data instead of current month..and if none is selected then current month data..?

How can we do this if we have String filters, Thanks in advance

The previous year months also shows the same months ago value as of the current year. Hence not useful to my data as my data has values for 3 years.

The method of getting N months back calculation won’t work even when you are in January but want to include November and December.

You're not taking into account that your end users may want to see all 4 months worth of data. You're assuming that if all boxes are selected to just display the current month.

Hey Thanks Bro, Filtered google to get here and this is close, so can I ask or any expert here some questions. I have a scenario 1. Status that I am set for slicer that has huge list. I cannot use this as this requires aggregate function to be given as must, but I cannot do aggregation and it is cribbing FTODefaultTest = If ( COUNTROWS(DISTINCT(ALLSELECTED(_Work[Status]))) < COUNTROWS(DISTINCT(ALL(_Work[Status]))), MIN(_Work[Status]), /* I cannot have MIN on values returned by system to select, I am not calling a measure. */ If ( SELECTEDVALUE(_Work[Status])= " Scheduled", MIN(_Work[Status]), BLANK() ) - I get blank, how do we fix this, 2. I want to set multiple options as default 3. Similarly i need to set 3 FY years from current year as default Any help?

where are you at bro