Forum Discussion
Dynamic Bookmark
Hi All, I have created two book marks 1. Last week 2. Select week By default, the "Last week" bookmark is selected, but users can choose the "Select week" bookmark to view data for other wee...
Hi Anonymous
Thank you for your response. I followed the steps you mentioned, but when I open the report for this week, I notice that the data from both the 19th of December and the 12th of December are being displayed. The calculated column (IsLastWeek) is filtering the data correctly, but I only want to see the data from the 19th of December. Ideally, this should automatically update to show the data for the last week when new data is entered in the following week.
The desired outcome is that when I click on the "Last Week" bookmark, it should display only the data for the previous week.
Thank you!
I think it this case, you also need to create specific column, called e.g. WeekName, with Date values like you have 12/12/2024, etc. and with specific text value 'Last week' for previous week (no date). And for Last Week bookmark, you need to use this text value in slicer.
If you would be using date values in slicer, PBI will always remember your last selection, which was in this case 12/12/2024 ... if you will change it to text field 'Last week', it would also stay selected by default, but in the background it would dynamically mean different timerange.... Example on month level:
You can eassily create it as conditional column: If IsLastWeek = 1 then 'Last Week' else WeekStart