Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago

Filter values for last Date only

hello, i have a matrix and I only want to filter the lastest month of data.  So if the value exist in a different month. It should not filter the table.  The filtering should only take place if the value exist in the latest Date (in this case May)

 

what is the best approach? thannks for any assistance

Need Help

6 Replies

    • ilcaa72's avatar
      ilcaa72
      Icon for Helper IV rankHelper IV
      8 years ago

      the last month in this Matrix is May... if I use the filter, it should only work for the column of May.  Right now it will filter the entire Matrix. i only want to Filter May (the lastest Month in the Matrix)

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

        So you only want to see those rows where in the last month of the matrix, the matched rates are between the conditions specified in the slicer.

         

        Am i correct?

         

        If yes, then share the link from where i can download your PBI file.