Week Filter

[jiji]

Hi Guys - Could you please help me create a week filter that could describe the days of the selected week? Can that be done in Power BI?

I have date filters; Year, Months, & WeekOfYear, and my lead would like to  see the days within the selected week num. Say, If We select 2022 May, week 23, we should be a able to  see "May 29 - June 4" or "May 22 - May 28".

I could have just  add a separate day filter but they want it within the week filter. Is it possible?`

[v-yalanwu-msft · Accepted solution]

Hi, @jiji ;

You could create a measure then add it into card.

Measure = CALCULATE(MIN('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month])) &
"-"&CALCULATE(MAX('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month]))

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DimaMD]

Привіт  @jiji ,  Try it

= " " MIN(data[dates]) і "-" MAX(data[dates])

but the 23rd week of 2022 is June