Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
73 | |
57 | |
38 | |
35 |
User | Count |
---|---|
83 | |
68 | |
59 | |
46 | |
45 |