Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello @jorgensorensen ,
You have to create a concatenated column for the same. Before that you have to create a week column.
For week column DAX will be as below:
Week Num = "Week " & WEEKNUM(Data[Date])
Next create a slicer column as you need using below calculation:
Slicer Value =
Var A = CALCULATE(MINX(Data,Data[Date]),ALLEXCEPT(Data,Data[Week Num]))
Var B = CALCULATE(MAXX(Data,Data[Date]),ALLEXCEPT(Data,Data[Week Num]))
Return
Data[Week Num] &
" - " &
YEAR(Data[Date]) &
"(" &
FORMAT(A,"dd.mm") &
" - " &
FORMAT(B,"dd.mm") &
")"
Now create a slicer sorting column called as week number sorting using below DAX:
Week Number Sorting = WEEKNUM(Data[Date])
select slicer value column and sort it with respect to slicer sorting column.
Then take slicer value column in to your slicer then the output looks as below:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |