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

[ssspk]

Hello Team,

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

Week Number Calendar = VAR _Wk =  WEEKNUM(data_customized[servertime].[Date]) RETURN "CW" & _Wk

For the above columnI have to chnage it like below image.

Need to create/edit a column like below?

I have to use the same column for the slicer for the CW filter filter the data.?

How to implement the above scenarios in power bi?

Thanks and Regards,

Siva

[samratpbi · Accepted solution]

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!