Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sjtalkar
Frequent Visitor

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

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...
Previous Week Visuals2.PNGPrevious Week Visuals1.PNG

3 REPLIES 3
sjtalkar
Frequent Visitor

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

 

 

 

 

Another way would be to use Field Parameter measures.

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.