Dynamic preselected selection in PowerBI slicer

[IshaDahra]

I am working on automation of a task which contains monthly data. I want my slicer to be automatically select the latest month data available whenever the data refreshes

[wardy912]

Hi @IshaDahra 

 Ensure your month column is sorted by a number column.

Add your slicer and make sure it's sorted by the month column descending.

Enable single select.

If you want to dynamically filter your page every time, just add the month column to the filter pane.

Select 'relative date', 'is in this month'

I hope this helps, please give a thumbs up and mark as solved if it does, thanks!

[IshaDahra]

From this, if next month's data is updated the previous month's data from slicer is not getting removed

[v-menakakota]

Hi  @IshaDahra  , 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @mdaatifraza5556 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

Can you please confirm whether the issue got resolved or not.
Thank you.

[v-menakakota]

Hi @IshaDahra ,

Can please confirm whether the issue has been resolved. If it is solved can you please share the workaround here.

Best Regards, 
Community Support Team.

[v-menakakota]

Hi @IshaDahra ,

Can you please confirm whether the issue got resolved or not.
Thank you.

[mdaatifraza5556]

Hi @IshaDahra 

Can you please share the snapshot of the slicer how you want 

you want to show only current month name in the slicer or something else


In my approch it will always select the current month having in your dataset 

If this answers your questions, kindly accept it as a solution and give kudos.

[mdaatifraza5556]

Hi @IshaDahra 

Can you please try the below steps to get your result ?

This is based on the max date you have in your table ( either it is max date as per you data or it is related to today)

1. Create a calculated column in your date table using below dax 
    

MonthLabel =

VAR CurrentMonth =

    EOMONTH('date'[Date], 0)

VAR LatestMonth =

    CALCULATE(

        MAXX(ALL('date'), EOMONTH('date'[Date], 0)),

        REMOVEFILTERS('date')

    )

RETURN

IF(

    CurrentMonth = LatestMonth,

    "Latest Month",

    FORMAT('date'[Date], "MMM-YYYY")

)

Now add a slicer ( use MonthLabel column) and select the Latest Month and then published it to the workspace.

whenever the use open the report it is always Latest Month is selected, later or you can change the month or by the help of year slicer you can also adjust this.

Result 

If this answers your questions, kindly accept it as a solution and give kudos.

[IshaDahra]

I have put Month name's name in slicer, if the latest month data in slicer is July-2025 and I publish it. Then, the data of August is loaded in folder to automatically refresh the dashboard, the selection of slicer doesn't changes to August

[mdaatifraza5556]

Hi @IshaDahra 

As you can see i have created a calculated column

In which i have named for current month to show Latest Month ( in calculated col)

and in the slicer i just selected Latest Month, Now whenever the new month data is added then that calculated column is re-run when it get refresh then again Latest Month will give the current month which is added into it .

I have just tried with a sample by adding next month for 1999. and it's working 



If this answers your questions kindly accept it as a solution and give kudos.

[jaineshp]

@IshaDahra

It would be great if you provide the data as well.

Best regards,
Jainesh Poojara / Power BI Developer

[IshaDahra]

It's month's names

[Arul]

@IshaDahra ,
There is no direct way to select the latest month always in the slicer upon data refresh but we have workaround.

Create a new calculated column based on the existing date column which will contains monthyear format as you mentioned for other months and "Current month" text for latest month. This will update as on when data is refreshed. Use this newly created calculated column in the slicer.

Please refer the file attached.

[Arul]

@IshaDahra ,

What kind of data you are using in the slicer ?

[IshaDahra]

It's Month names