Forum Discussion

ps1dr3x's avatar
ps1dr3x
New Member
9 years ago

(Matrix) exclude at page level

Hi everyone,

 

in Power BI's matrices is possible to exclude a value (by right clicking on a cell):

 

 

but the exclusion affects only at visual level (matrix on which the exclusion is made):

 

 

 

 

It's possible to exclude the selected value at page level (so the value is filtered also in other matrices that uses the same rows-cols)?

 

What i need to do is to filter matrix cells that are less than a settable value, but it seems that i can't achieve that with filters because matrices' cells in this case are an implicit calculation based on a measure (COUNTROWS + FILTER) and row-col values combination.

 

Thanks for any help,

_m

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Move that filter down to the Page Level right underneath your visual level filter.

    • ps1dr3x's avatar
      ps1dr3x
      New Member
      9 years ago

      Hmm... Thanks for the answer, but i think that is not possible: Rows, Columns and Values contents are draggable, but the Filters section's contents are not :\

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        Hi ps1dr3x,

         

        Currently, the exclude option works as a visual level filter, and I don't think there is an option to extend this to be page/report level filter.

         

        Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

         

        Regards