Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ssspk
Helper III
Helper III

Week Number filter using slicer and display ending date of the CW week?

Hello Team,

 

I have a Column as shown below with Formula Measure in the table column,

Calandar_week_3.png

 

 

 

 

 

 

 

 

 

 

 

 

Week Number Calendar = VAR _Wk =  WEEKNUM(data_customized[servertime].[Date]) RETURN "CW" & _Wk
 
Calandar_week_2.png
 
 
 
 
 
For the above columnI have to chnage it like below image.
Need to create/edit a column like below?
calandar_list.png
 
 
 
 
 
 
 
 
 
 
I have to use the same column for the slicer for the CW filter filter the data.?
Calandar_week_1.png
 
 
 
 
 
How to implement the above scenarios in power bi?
 
Thanks and Regards,
Siva
1 ACCEPTED SOLUTION
samratpbi
Super User
Super User

Hi,

You need to have a date table where you should have week no ( 1-52/53) and also Week ending date. This is standard in date table. Once you have that, create a slicer on the week no, which will give you a "between" slicer and you should be able to drag. Now by default, week no will appear in values. But you can first change color to white to make those disappear and then create 2 measures.

Min EoW = 
"CW" & 
MIN(d_date[Week of the Year]) & 
" (Ending " &
FORMAT(MIN(d_date[End of Week]), "dd mmm") &
")"

 

Max EoW = 
"CW" & 
MAX(d_date[Week of the Year]) & 
" (Ending " &
FORMAT(MAX(d_date[End of Week]), "dd mmm") &
")"
Put those 2 measures in a card visual and allign on top of your slicer.

 

Hope this resolves your problem.

If this helps to resolve your problem, then please mark it as solution provided, Thanks!

View solution in original post

1 REPLY 1
samratpbi
Super User
Super User

Hi,

You need to have a date table where you should have week no ( 1-52/53) and also Week ending date. This is standard in date table. Once you have that, create a slicer on the week no, which will give you a "between" slicer and you should be able to drag. Now by default, week no will appear in values. But you can first change color to white to make those disappear and then create 2 measures.

Min EoW = 
"CW" & 
MIN(d_date[Week of the Year]) & 
" (Ending " &
FORMAT(MIN(d_date[End of Week]), "dd mmm") &
")"

 

Max EoW = 
"CW" & 
MAX(d_date[Week of the Year]) & 
" (Ending " &
FORMAT(MAX(d_date[End of Week]), "dd mmm") &
")"
Put those 2 measures in a card visual and allign on top of your slicer.

 

Hope this resolves your problem.

If this helps to resolve your problem, then please mark it as solution provided, Thanks!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors