Hierarchy Date Slicer Month and default Previous Week duplication when month changes

[sjtalkar]

Hello,

We have a requirement where the user would like to open the Power BI  report to a default of the previous four weeks selected in a hierarchical date slicer. The date slicer has Year, Month and Week End Dates in the hierarchy.
We created a new column in the calendar table that marks the previous week, previous 2 weeks.... This updates with the refresh without issues, that is as the week end changes, the the value "Previous Week" is displayed against the correct Week End Date.

We published the report to the service with Previous Week, Previous 2 weeks , Previous 3 weeks and Previous 4 weeks selected. We see this default working fine when all the weeks are in the same month. When the month changed from September to October,  We see the Previous Week in September continue to be present and is also selected. The Previous Week also shows up in October and is NOT selected. We can assume as October rools by we will see duplication of Previous 2 weeks and so on in Spetember and October.

Is this the right behavior and are we misunderstanding the usage of the default selection? If not, can someone help with a resolution.
NOTE:
1. The data is refreshed and the new set of dates for previous week is duly updated in Power Query . Screen shot attached.
2. When the mnth changes we now have Previous Week in the visual in September and October

Here is an issue we found similar but not same as described as above: Default slicer selection in Power BI Desktop not retained after publishing · Issue #84 · liprec/azur...

[sjtalkar]

We do not expose the Filter pane for other business reasons. The user, yet, needs to have the flexibility to choose from both the set of relative past weeks as well as any week in any year. Thanks for your reply but I found a solution on Medium that is more aligned with our requirement. Dynamic default slicer value in Power BI | by Mateusz Mossakowski | Microsoft Power BI | Medium

[lbendlin]

Another way would be to use Field Parameter measures.

[lbendlin]

We have a requirement where the user would like to open the Power BI  report to a default of the previous four weeks selected in a hierarchical date slicer. The date slicer has Year, Month and Week End Dates in the hierarchy.

Abandon your slicers and use the Filter Pane.  It has built-in relative date filters.