Forum Discussion
Helper IVHow to get last five days date in button.
Resident RockstarHi, here is the workaround you can use:
1) Take a bookmark of the page, then on your matrix/table under Filter on visual set Date Filter to TOP N Bottom 5 latest date.
Create another bookmark named 5 last days. Go to insert button-bookmark navigator and here you are, having 2 buttons switching between all and last 5 dates.
The second workaround is just to create 2 measures, Sum Sales and Sum Sales for the last 5 days and then add filed parameter with thos 2 measures as a field. This way you can show both values at the same time or single select from the slicer what to show all sales or last 5 days sales.
Heena_9980400Hi olgad ,
Thanks for your input,
only when I click on the last 5 days it should show the last 5 days' date and the remaining it will have all dates and data.
I am just a little bit confused here can you please guide me go through !!
Thanks in advance!!
- olgad
Hi, let me know where you get confused so i can explain it in a different way.
1) You have you all dates all data-take a bookmark
2) Then on the page set up a date filter for 5 last days-take a bookmark
Insert the bookmarks on the page-insert button -bookmark navigator. Click on the first bookmark you have all data click on the second you have 5 days
- Heena_9980400
Hi olgad ,
If you have any screenshots or dump pbix, please can you share with me. I just want to know for date how your keeping bookmark.
Thanks in advance,
Hk