Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am building a report that will refresh every day with data from the previous day. The visuals only display data from a certain day, so first of all the user havo to select a date (from a date slicer).
Noow, I am familiar with the standard date slicer (I usually use dropdown styles). What I am looking for is very simple button. And if a user pushes this button the date in the date slicer increases with one day. Obviously if this is possible, than it would be easy to do the same on the other direction (get the previous day).
The reason why this button is necessary, because if I have two years worht of dates in a dropdown slicer, than it is not very user friendly to always find the necessary date (eg. 1 year ago), choose it, than choose the day before (1 year and a day ago)... It is super annoying.
For the life of me I cannot find a solution to this... And I refuse to believe that nobody ever tried to create a slicer/button like this. It is super easy to implement in Excel, and I thought that Power BI supposed to be at least as advanced as Excel 🙂
If you have any idea for this problem please share!
Hi @Astorre72 ,
See if this slicer can meet your needs.
Or you can try bookmarks and buttons.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Create a new one page report that includes data for the year and the previous day. Use this page as a bookmark and bind the bookmark to the button
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.