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

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi BratKat 

    Can you show me some sample data of the [Team Date 01] column? Because the two ways can work on my pbix file.

     

    Best Regards!

    Yolo Zhu

     

     

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

      Example of column

       

       

       

      • 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.