topic Re: Setting the default date slicer to current year in DAX Commands and Tips

Setting the default date slicer to current year

jostnachs — Tue, 25 Jun 2024 02:12:56 GMT

Hi all,

I have a requirement where i have a date slicer as below . These are the min and max values in the dataset. Now my requirement is, when i open the report, the report has to show current year (i.e. 01/01/2024 to 31/01/2024) instead of the below values. How can I do that? when I change the relative dates in filter, the user is not allowed to select other years except 2024 . i want user to select other years as well. So can someone suggest how I can do that?

Re: Setting the default date slicer to current year

lbendlin — Wed, 26 Jun 2024 00:40:51 GMT

Here is the general approach for that pattern:

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

Re: Setting the default date slicer to current year

Anonymous — Wed, 26 Jun 2024 09:11:25 GMT

Hi jostnachs ,hello lbendlin
Thank you for your prompt reply!

According to your description, you want to “set the default date slicer to current year” and can also filter against all other dates.

Per my test, currently the default slicer cannot do this.

Therefore, we suggest you use the Preselected Slicer from app source as a workaround.

Here are steps you can refer to:

We get the three point in the "Visualizations", and we click the "Get more visual":
Then we search the "Preselected Slicer" and add the visual to our Power Bi Desktop.
Then, we create a table with one column , and the value is True and False, like this:
Later, we can create a measure to define which the date we need to default preselected. If we need to default preselect then we return True else return False.
Flag = var currentYear=YEAR(TODAY())
VAR _maxcurrentYear=CALCULATE(MAX('Table'[Date]),FILTER('Table',YEAR('Table'[Date])=currentYear))
var _mincurrentYear=CALCULATE(MIN('Table'[Date]),FILTER('Table',YEAR('Table'[Date])=currentYear))
var _date = SELECTEDVALUE('Table'[Date])
return
IF( _date<= _maxcurrentYear&&_date>=_mincurrentYear,TRUE(),FALSE())
Lastly, we drag the slicer fields, default selected measure and status column as shown below:
Note: it’s necessary to click the red reset button in the upper right corner to recover the default selections.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best regards,

Joyce

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

Re: Setting the default date slicer to current year

jostnachs — Sun, 30 Jun 2024 18:14:40 GMT

Thank you so much for the idea.... But using this particular additional visual is hindering the performance of the report. I tried it. The visual takes a lot of time to load and also its not possible to show it as in between slicer which is what the customer requested for......

Re: Setting the default date slicer to current year

Anonymous — Wed, 03 Jul 2024 01:47:12 GMT

Hi jostnachs，

Thank you for your feedback, we recommend send your feature request by submitting your ideas in the following link:

https://ideas.fabric.microsoft.com/

Best regards,

Joyce