Last Period

[navinkb9]

Team,

I have a requirment to define the default values as Last Period always.  In the given scenario I am in P07 but I would want the slicer to have P06 selected by default. Same way, when I am running report for P08, it should select P07 by default. If it was a date field we can do this easily. Now the question here is that, the Year Period Column is in Text Format and I am not able to find a way on how to acheive this.

 Just FYI.. Each period has defined number of days for example see below 

[navinkb9]

I tried but I am not able to acheive this yet

[v-cgao-msft]

Hi @navinkb9 ,

Please try this custom visual:

Preselected Slicer

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data