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...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi BratKat 

Please try to keep the ascending ranking of the [Team Date 01], then create a calculated column

e.g 

Index = COUNTROWS(FILTER('Table',[Team Date 01]<=EARLIER('Table'[Team Date 01])))

Then modify the Tooltip measure.

Tooltips = SUM('Table'[Index])
Then put the measure to the tooltip, then select sort by the measure.
 

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.

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

The MonthWeek item is a measure in my data so does not appear in looking at the data in Transform, tried you method but made it worse. Is there a way I can format the date to appear instead of for example. January Week 1 to appear as 1 Week January so I can sort numerically ? Thank you 

 

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

    Its possible may be creating the graph wrong. Am using my MonthWeek measure in the Slicer but using the Team Date in the X-Axis. Could that be an issue ? I did try using the Team Date in the Slicer however then I did not have the option of using "between" in the Slicer. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  BratKat 

    Modify the Tooltip measure.

    Tooltips = COUNTROWS(FILTER(ALLSELECTED('Table'),[Team Date 01]<=SELECTEDVALUE('Table'[Team Date 01])))
     
    Then put the measure to the tooltip, then select sort by the measure.

    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.