Forum Discussion
BratKat
Microsoft Employee
3 years agoWeekly data and slicer
Have a graph that uses a Slicer (using between) and a measure to get each week per a column of the dates we reference. MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Ite...
Anonymous
3 years agoNot applicable
Hi BratKat
1.Click the MonthWeek column, then select sort by [Team Date 01] column
Then put the MonthWeek column to the visual
Output
2.You can create a measure
e.g
Tooltip=SUM('Work Items'[Team Date 01])
Then put it to the tooltips, and select "..." of the visual and select sort by "Tooltips" and "ascending"
Then, no matter how you filter the slicer, it can appear in increasing order.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.