Slicer in power bi

[Kishore_KVN]

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!!