Forum Discussion

dedelman_clng's avatar
dedelman_clng
Community Champion
6 years ago
Solved

Matrix not affected by visual filter

PBI Desktop Jul 2019 version

 

It does not appear that the Matrix visual is not impacted by a Visual Filter in the same way other visuals are (table, column/bar, etc).

 

Here is a simplistic example

My data looks like this:

DateCategoryAmount
7/31/2019A$0.00
7/31/2019A$4,514.57
7/31/2019A$86,053.16
7/31/2019B$15,166.67
7/31/2019B$20,212.15
7/31/2019C($2,837.13)
7/31/2019D$1,892.89
7/31/2019D$2,750.00
7/31/2019D$3,750.00
7/31/2019D$7,322.59

 

I create a table with those three columns

Note that Category C has a negative value.

I then apply a filter on Amount

And category C is now filtered out

 

Convert the same to a Matrix, with Date on the row, Category on the Column and Amount as the value

Note that Category C is visible. Now apply a filter to Amount.

Category C is still there ???

 

Is this a bug or an unfortunate feature of the matrix visual?

 

Thanks,

David


ETA: If I move Category to a row under Date, the filter works as expected.

 

  • Hi dedelman_clng ,

    Microsoft reply that:

    This is by design. The matrix applies the measure/value filter at the Row totals granularity, not at the cell granularity. In the forum example the filter is applied to each value of Date, rather than combos of Date - Category.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Icey's avatar
    Icey
    Community Support

    Hi dedelman_clng ,

    Microsoft reply that:

    This is by design. The matrix applies the measure/value filter at the Row totals granularity, not at the cell granularity. In the forum example the filter is applied to each value of Date, rather than combos of Date - Category.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Community Support

    Hi dedelman_clng ,

    I have reported this issue internally and will update here once I get any information.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.