Forum Discussion
Automatically change/set filter selection
Hi there... I start my Power BI dashboard by showing users a page that I call "Select". It's primary purpose is to allow users to use a filter that shows a series of end dates. i.e. 1st July, 7th...
I'm struggling to see how to preselect a slicer value based on the most recent day, so I'll be curious to see if someone chimes in.
To make it easier for the Execs though, you can change the slicer to a "Relative" visual with the dropdown in the slicer, then set it to last 1 days. Then they have to pick the last day.
Or set it to a list in descending order. Then there is just a simple box to check.
I also know you can set it in the desktop and publish it, but you'd have to do that every day, or time period, to push it up. Not ideal....
Setting it to relative is a great option! - Last 1 week.
Testing now.
- David