Forum Discussion

Leeny127's avatar
Leeny127
Frequent Visitor
8 years ago

Matrix Values are not Affected by Date Slicer

Hello - I have a matrix that shows "# of Packages Reviewed" (and other values seen below) for various people. The values are all calculated by measures.  Next, I have a "Months" slicer that should fi...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Are you sure that the direction of the relationship is correct?

  • Leeny127's avatar
    Leeny127
    Frequent Visitor
    8 years ago

    Greg_Deckler I believe so...when I change the Cross filter direction, it still has no effect on the values but does mess up the 'Months' visual display (only showing two months in the slicer).

     

    It has to be something with the measures because the date slicer does filter the matrix Rows (Team and PL Name); it just doesn't filter the values...for instance:

     

    Cam has reviewed 2 packages

    - one in July  - one in Aug

     

    When the 'July' filter is applied, the matrix shows both of Cam's reviews

    When the 'Aug' filter is applied, the matrix shows none of his reviews.

     

    So the measure is counting all of the person's package reviews and displaying them only in the first month they did them.

    • v-danhe-msft's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Leeny127,

      Could you please share the pbix file is possible?

       

      Regards,

      Daniel He

      • Leeny127's avatar
        Leeny127
        Frequent Visitor
        8 years ago

        v-danhe-msft Thank you for your reply.  I am unable to share the pbix per my company's security rules.