Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Weekly 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...
BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Additional information:

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

  • BratKat's avatar
    BratKat
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Thank you, I tried this however it didn't resolve - 

    Even if I change the sort method, still off. 

    Measure created = 

    Tooltip = SUM('Work Items'[Team Date 01])
    Using this measure in prevous screenshots to sort by weeks 
    MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Items'[Team Date 01])
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi BratKat 

      Did you put the measure to the tooltip, and you can try the first method  I have offered, after testing, it can be work.

       

      Best Regards!

      Yolo Zhu