Last 4 weeks based on slicer of week number

[Anonymous]

Hi All,

I hope i can explain this correctly for you all and any help is greatly appreciated.

please see below the dashboard i have. it is sliced on week number which is in its own dates table using the calendar auto command.

I want to show the bottom left visual for week 6, 7, 8 and 9 as you can see its only showing week 9 at the moment as the week number slicer is set to week 9 top right.

so based on the week number slicer at the top right can it show the last 4 weeks just in that visual. I also know about the edit interactions to stop it taking on that specific slicer.

Thanks,

Adam

[ion_donica · Accepted solution]

Hi @Anonymous ,

if you have a date, the relative filtering provided by Power BI could do the trick without entering in too much DAX:

Apply this to your visual and check if it is exactly what you want.

Best Regards,

ID

[Anonymous]

thanks a lot i think that has solved it! will that just pull today date every time then and show the last 4 weeks?

[ion_donica]

Yes, if you select include today, it will give you the las 4 weeks strating today.

Just make sure to check the diference in terms or result from Calendar week and Week and see which one suits you the most.

[amitchandak]

@Anonymous , you will need an additional independent date table for that.

refer this case with date table and 12 month

https://www.youtube.com/watch?v=duMSovyosXE