"Current year" as default value for year slicer hack?

[Anonymous]

I know this is not supported yet™ but I'd like to ask if someone knows any workaround...

I've thought about a couple of things:

• Having every value displayed in the report as a measure like this: IF ( ISFILTERED ( yearColumn ), measure, CALCULATE (measure, FILTER (current year))) So, by default, every measure would be filtered by the current year except if you select the year filter. This is time consuming (especially if you have to modify tens of reports), unintuitive for the end user and not always possible.
• Two slicers, one (selected) with only one option (the current year) and another one with all the years. Also not very intuitive nor pretty.

The required functionality is: always load the report filtered by the current year and still have a easy way to change between years (like, with a simple slicer).

Any ideas?? 

Also, keep voting!

[ahmadov_10]

Hello : i want to see my slicer by default filtered when i open my report in the default value (auto filtering) 

I tried isfiltered function but didn't work . (it seems like when your customer demand to show by defaut sales data in last year and after he have the choice to change slicer value) 

[Anonymous]

Hi, Is this solved ?? I have a similar requirement where i have to show a default year in filter and then give the end user power to filter all the other years too. Could you help ??

[ahmadov_10]

Until now (May 2023)

there is not an option to configure directly to set a default value on the Power BI Slicer. But as an alternative solution, we can define a bookmark default year 2015 for example and use it with a reset button. After , oblige the client to use the slicer initially to display the visuals (use bookmarks to put blank frames to hide the visuals and will not be displayed except when using Slicer).

https://community.fabric.microsoft.com/t5/Desktop/How-can-we-set-Slicer-to-set-specific-value-as-def...

[Anonymous]

Or may be can we use a measure with selectedvalue as a work around for this issue ?? Your thoughts ??

[ahmadov_10]

you want to say : a measure that takes a formula : selectedvalue(slicerValue , "defaultValue") and you use it in the filter section of Slicer to filter the slicer by a default value.
--> didn't work , i tried it : the measure use a DAX function selectedvalue and i think this function is based of the slicer behavior.
you can try a bookmark or search again for another solution.

[Rickmaurinus]

You could also go the way of performing the logic in Power Query. You would then check whether a year equal the Date.Year( Date.From( DateTime.LocalNow() ) ), and if so replace the year by the text: "Default". 

This ofcourse turns the column to a text type. So it would be good to have a regular 'year' column and a 'year default' column. 

You can see more on this here: https://gorilla.bi/power-bi/set-default-slicer-value/

--------------------------------------------------

@ me in replies or I'll lose your thread

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

[ahmadov_10]

Hello , i follow your solution but it doesn't satisfy my need : i want to see my slicer by default filtered when i open my report in the default value (auto filtering) 

I tried isfiltered function but didn't work . (it seems like when your customer demand to show by defaut sales data in last year and after he have the choice to change slicer value) 

[Anonymous]

Hello,

You can select the current year in the slicer and save,publish the report, which acts as default value.

The user will have the ability to filter other years if they want to. 

If you have any other calculations to be performed based on the selection. You can use the "SELECTEDVALUE" function in the measure which brings the Current year(in dafulat case)/the user selected value in all other cases.

Hope this helps.

Let me know if you have any questions.

Thanks,

Soumya

[v-yuta-msft]

Hi ThunderRoad,

Have you solved your issue by now? If you have, could you kindly mark my answer to close the thread?

Regards,

Jimmy Tao

[v-yuta-msft · Accepted solution]

Hi ThunderRoad,

You may need to create an addtional calculate column to achieve current year and then use that column to filter the chart, similar case for your reference: https://community.powerbi.com/t5/Service/Default-value-in-Report-Filter-Panel/td-p/47574.

Regards,

Jimmy Tao