how to assign default value for slicer with single-select

[Anonymous]

I have a slicer that has single-select on, as shown below:

These values come from a table that changes its date range in each refresh.  This table is called 'Fcst Period Slicer', and looks like the following:

I first published my report in May 2020.  Now that it is June 2020, I need the default slicer selection to be 'FY20 Pd3 (Jun)'.  As I understand it, Power BI keeps the selected value from report publish time (i.e., 'FY20 Pd2 (May)') for all dataset refreshes thereafter, even if that value is no longer present in the data table.  And, as far as I know, Power BI still doesn't offer support for dynamic default values in slicer.  How can I make my slicer default to the earliest / minimum value in 'Fcst Period Slicer'[Period Label] in each dataset refresh?

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Anonymous ,

As you mentioned, power bi has not supported dynamic default slicer currently.

Here is an idea about default selected slicer, you can vote for it to help us improve power bi and make this feature coming sooner.

Best Regards,
Yingjie Li

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

[amitchandak]

@Anonymous , You can create something like this in Date Calendar

This Month = if(format('Date'[Date],"YYYYMM")=format(TODAY(),"YYYYMM"),"This Month",[Fcst Pd])

You can select This month and this will remain on the current month Always

[Anonymous]

@amitchandak 

I don't understand.  Are you saying to put that as a calculated column on another table and to use that calculated column in my slicer?

[Anonymous]

@amitchandak 

A solution that involves returning a generic current month value / label like "This Month" instead of the actual month value (e.g., "FY20 Pd3 (Jun)") is not permissible in my report.  Users need to see the actual month value for the current month, not a generic value.