topic How to show data for last 4 weeks based on selected week in slicer? in Custom Visuals Development Discussion

How to show data for last 4 weeks based on selected week in slicer?

NebojsaZ88 — Fri, 25 Nov 2022 12:57:45 GMT

Hi,

I am currently stucked trying to figure out how to show in table data for previous 4 weeks based on selected week in slicer? Ideally, if it is selected current week (2022-11-26 - I am showing as Week Ending), to have in Rows only weeks for current month, meaning:

2022-11-19

2022-11-12

2022-11-05

In my Calendar table, I have columns:

1) Week Ending, [Date]-MOD([Date]-1,7)+6

2) This Week Slicer = if( value(YEAR (NOW() ) & 100 + WEEKNUM (NOW() )) = value(('Calendar'[Week Year Number])), "This Week",FORMAT('Calendar'[Week Ending],"YYYY-MM-DD")) - I am using this one for slicer where "This Week" represent current week (in my case 2022-11-26)

3) Last Week Ending = DATEADD('Calendar'[Week Ending],-7,DAY) - I am using this one for table to show always data for previous week based on week selected in slicer.

...but how to show 4 previous weeks instead of only one? Why slicer does not alow me to show list of all previous weeks, instead of only one?

Re: How to show data for last 4 weeks based on selected week in slicer?

lbendlin — Sat, 26 Nov 2022 23:07:39 GMT

Weeks and Months are not compatible. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: How to show data for last 4 weeks based on selected week in slicer?

NebojsaZ88 — Wed, 30 Nov 2022 14:48:58 GMT

Never mind. I fould solution. Thanks anyhow.

Re: How to show data for last 4 weeks based on selected week in slicer?

Ptripath — Wed, 13 Dec 2023 13:38:57 GMT

Could you please share the solution we need to implement same.