Forum Discussion

markmsc's avatar
markmsc
Resolver I
4 months ago
Solved

Filtering out zero/blank Matrix rows, part XXXVI

Hi all -- I have a variant of the old question "how do I filter out zero rows in a matrix visual" that I can't work out.  Surely it has been addressed in here somewhere, but I've not turned up the ri...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    Hi markmsc,

     

    You can try below measure and use it as a filter on table visual

     

    Inventory Row Filter =
    VAR NonZeroMonths =
    COUNTROWS(
    FILTER(
    ALLSELECTED('Date'[Month]), -- your column field (May, June, July)
    NOT ISBLANK(CALCULATE([Inventory])) &&
    CALCULATE([Inventory]) <> 0
    )
    )
    RETURN
    IF(NonZeroMonths > 0, 1, 0)

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

OwenAuger's avatar
OwenAuger
Super User
4 months ago

Hi markmsc 

I would normally suggest creating a measure (or an equivalent calculation item) that converts unwanted values to blank, and rely on the default Power BI behaviour where completely blank rows or columns are hidden (due to SUMMARIZECOLUMNS).

However I'm not certain that would meet your requirements.

 

To clarify, assume this is the original matrix with an additional item "Erasers" and a Total column:

 

Would you be happy converting the above to either of these options, or something else?

Option A (all zeros converted to blanks):

Option B (zeros converted to blanks only where entire row is zero/blank):

 

  • markmsc's avatar
    markmsc
    Resolver I
    4 months ago

    Hi OwenAuger -- thanks for your reply.  I would want result B as shown in your post.  Please see my response in this thread to @grazitti_sapna for the solution I went with.  Thank you again for your help.