Forum Discussion

admiralman's avatar
admiralman
Advocate II
8 years ago

Matrix - Suppress Row

I have the need to have a Matrix that has 3 Categories with 5 rows per Category show over 12 month columns. I have this working just fine but I also need to have a dropdown that acts as a toggle that when switched will only show 4 rows per category. I need to have one row removed completely not just showing zeros. Once way that I can see to approach this is to have two Matrix visuals, one with 5 rows, one with 4 and use the Bookmark/Selection Pane approach to hide and show them. I would like to avoid this if possible thus my question. Thanks in advance. 

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi admiralman,

     

    Please check out the demo here if you have a model like below.

    Measure =
IF (
    HASONEVALUE ( 'IfHide'[Rows] ),
    IF (
        MIN ( 'IfHide'[Rows] ) = 5,
        SUM ( 'Sales'[Sales] ),
        IF (
            MIN ( 'Categories'[Product] ) IN VALUES ( 'IfHide'[Hide] ),
            BLANK (),
            SUM ( 'Sales'[Sales] )
        )
    ),
    SUM ( Sales[Sales] )
)

    Matrix_Suppress_Row

     

    Best Regards,

    Dale

    • admiralman's avatar
      admiralman
      Advocate II
      8 years ago

      That is a great solution and I will keep that in mind for the future. Unfortunately I am trying to suppress an entire measure itself from a matrix...not just a row of a measure.