how to set default date in slicer

[cascador84]

Hello,

i would like to know if it possible to set a default start / from date to first day of current year (by example) to current date in a Power bi slicer, like:

the minimum date should still depend of dataset, but the from date must be the first day of year

using relative dates is not compliant with user requirement (they want to be able to "play" with slider, but by default, the would like to have the first (from / start) date to the 1/1/xxx.

thank you in advance.

regards

[Anonymous]

Hi @cascador84 ,

Please try below steps:
1. below is my test table

Table:

2. create a new datetime table with below dax formula

Table 2 = CALENDAR(DATE(YEAR(TODAY()),1,1),LASTDATE('Table'[Date]))

3. add a slicer with Table 2[Date] column

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cascador84]

Thank you for quick feedback.
but this is not the requiremen.
We don't want to limit the date slicer to begining of january to current date, but just having the left part of slider to first of january, and then, be able to select date before (as it present on my first screenshot).

regards

[Anonymous]

Hi @cascador84 ,

To my knowledge, your requirement could not be realized currently.

If you want this in  Power BI, let the power bi community to know this things and give your votes at  Power BI site's feedback -Ideas (powerbi.com)

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cascador84]

thank you for quick feedback.
But could we do this automatically ?

and using relative date will hide the slider.

regards

[MAwwad]

Go to Filter on this visual 

Then Set up the filter on this visual > Relative date> choose the date you want to start after