Forum Discussion

Frequent Visitor

10 months ago

Solved

Filter date using bookmarks PowerBI

I would like to change the date daily by clicking on the arrow. Is this even possible ? Many thanks in advance.

MFelix
10 months ago
Hi SeymaKalay ,

The usage of bookmarks altough they allow to have the specific data values stored and get to a "defaut" value they are not flexible enough, in the example you are giving you would need to have a 2 bookmarks for all the dates that you have one for the left arrow and another for the right arrow. Be aware that this is for page meaning that if you want to have this type of UI/UX on all the pages you will multiply the number of bookmarks.

The slicers on Power BI allow a couple of things like between values, etc. For this custom look and fell you can always try custom visuals:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/truvizinc1674781244292.date-picker-by-powerviz?tab=Overview

https://appsource.microsoft.com/en-us/product/power-bi-visuals/xviz.inforiver-superfilter?tab=Overview

You can also try to play around with a single select slicer and a card visual on top of it to get the final resul like this:

Super User

10 months ago

Bookmarks captures a state of the report but not the values comes after or before the current one so in your case that means creating a pair of bookmarks for every date selection - one each for the back and forward button.