Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Power BI that refreshes the data fine, but the slicer does not update and show the most recent data. The end users don't realize the slicer is showing previous date and need to open the drop down and select the new date.
Is there a way to have the slicer automatically select the most recent dates after report refreshes?
I've tried the solutions (use relative filter, calculated column) in the community, but none seem to work for the report. The only thing I haven't tried is a date table, but that seems to be extreme for a slicer.
Solved! Go to Solution.
@v-kelly-msft Hi Kelly, Thanks for the link...I tried it and wasn't able to get it to work. it's ok, it was more of making it more convenient for the end user to see most recent dates in the slicer. they now know to check the slicer.
Hi @Anonymous ,
You can create a calculated column with a measure to make the default selection available.
For details,pls refer to :
https://www.reddit.com/r/PowerBI/comments/8vta4f/how_to_set_a_default_slicer_value/
@v-kelly-msft Hi Kelly, Thanks for the link...I tried it and wasn't able to get it to work. it's ok, it was more of making it more convenient for the end user to see most recent dates in the slicer. they now know to check the slicer.
Hi @Anonymous,
Is your issue solved?Can you mark the reply as answered to close it?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.