Let's say that I have a YYYY-MM filter. Is it possible to have it picked the latest month from the list of all available YYYY-MM? I've already disabled 'Allow users to save' so that I was able to save the dashboard with the latest month as of now but next week I need to manually save the new latest. So, I was wondering if there is a way to do it automatically i.e. show only the latest value in the filter.
You can achieve your requirement by creating calculated column like below so it will show only latest value in your slicer. I hope I am getting right from your question. Is it something differ from my understanding so please let me know whether I caught the right track or not.
If I answered your question so please mark this as a Solution.
Thank you for the reply! I still need all months in the slider, I just want the selection to be automatically done on the latest month and have it changed automatically to the next latest month next month.