Weekly data and slicer

Additional information:

The Team Date is from AzDo Work Items as the date of the task per item. 

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.

Tried the first method (Click the MonthWeek column, then select sort by [Team Date 01] column) and recieved this message 

Yes I added the measure to the tooltip for the graph 

BratKat, changing your analysis to the week of the year would give you better results as week of month analysis is fundamentally flawed for comparable analysis.

If you are slicing by month & week, you will get strange and incomparable results in your visualizations.  I would suggest not going about it this way. For example, if the first or last week of the month had anything other than 7 days in them (which they always do), then they would not be comparable to anything and would give misleading results.

MonthWeek column does not appear in Transform Data, unfortunately cannot share my pbix file as it is proprietary as it is FED data. Is there a way to rewrite my current column