Forum Discussion
Dynamic preselected selection in PowerBI slicer
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.
It's month's names
Super UserIshaDahra ,
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.