Forum Discussion

ilcaa72's avatar
ilcaa72
Helper 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 v...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

What exactly do you mean?  What result are you expecting?

ilcaa72's avatar
ilcaa72
Helper 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
    Super 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.

    • ilcaa72's avatar
      ilcaa72
      Helper IV
      8 years ago

      thanks.  I want to see all the data. But the filter should only take into account the values in the lastest date column (in this case May).

       

      if you filter between 70-80, but May column does not contain values between 70-80 it should not filter the table, even though values 70-80 exist in another column. hope that made sense.

       

      https://1drv.ms/u/s!Av69y58QJYzRjyE4igUTbHkFchba

       

      thanks again.