Forum Discussion
Week Filter
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?`
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.
2 Replies
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.
