Create custom week filter where one can write/select weeks (same like date range)

[MianAhsan]

Hi everyone,

As shown in the image below, I'm looking for a solution to create a custom week filter where one can write weeks (same as the date range).

I have already created an example PBI file (created for another question, but we can also use it for this question), where both Power BI & Raw data is available. I'm using the Calendar (Date) table, which is already connected with the data model and working fine. 

Thank you in advance for your support. 

Let me know if you have access to these files.

Regards,

Mian

@Daniel29195 , @amitchandak , @Anonymous 

[jdbuchanan71 · Accepted solution]

@MianAhsan 

Add a column to your Date table like this.

Year Week =
INT ( YEAR ( [Date] ) & FORMAT ( WEEKNUM ( [Date] ), "00" ) )

Then put that column in a slicer.