Skip to main content

Power BI

Needs Votes

Relative data slicer Last Full X weeks / months or years

Vote (14) Share
Jordi-f's profile image

Jordi-f on 18 Sep 2018 21:43:08

It should be possible to use a combination of the XXXX and XXXX (Calendar) relative data slicer. In the current implementation you are not able to analyze complete weeks / months or years with the current week / month or year in scope.

The normal relative date slicer will set the period for for example 3 weeks to literally 21 days back.

The (Calendar) relative data slicer will set the period to the last 3 weeks without the current week.

The combination should be possible to get the last 3 full weeks / months or years

Referring to the ticket on community:
https://community.powerbi.com/t5/Desktop/Using-relative-date-slicer-to-get-last-3-full-weeks/m-p/518364/highlight/false#M242385