Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Team,
I have a Column as shown below with Formula Measure in the table column,
Solved! Go to 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!
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!