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.
From this, if next month's data is updated the previous month's data from slicer is not getting removed
Super UserHi 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.