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!

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 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) )

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.

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.

Great solution! Thank you so much!

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!

How did you create the month's tabs?

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?

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.

Great video!

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)

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

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

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

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

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

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 :)

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.

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??

How did you get the Amount column?

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.

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?

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

What about for multirow cards?

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

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

Thanks. Great video tutorial.

Life saver....thanks!

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..?

Indeed a cool trick !!!

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!

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

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

where are you at bro

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

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.

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?

Nice!

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?

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

👍👍👍