Forum Discussion
Solved
Dynamic preselected selection in PowerBI slicer
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
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.
