Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
5 years ago

Matrix Visualization - Suppress Zero and Missing Rows

Hi,

 

I am currently using a Matrix Visualization, I want Suppress Zero and Missing Rows?

Currently all the Rows are showing because of the way the DAX Measure is being calculated and cannot think of an alternative way to deal with this.

 

Basically I want those Rows to be grouped as blank or Null and appear on the Visuzalization, is this possible?

 

Thanks

 

 

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI AvPowerBI 

    Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

    from what I understand, I would use

    Visual Control = 
    var _result = 
    CALCULATE(
        SUM('Table'[Value]),
        ALLEXCEPT('Table','Table'[Category])
    )
    return
    IF(
        _result>0,
        1,0
    )

    Then,

     

  • AvPowerBI , not very clear. Try measure like

     

    if([measure] =0 , blank(), [measure])

     

    if(calculate([measure]) ,allexcept(Table,Table[row])) =0, blank(), [measure]) // row is column on row.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, AvPowerBI 

    Could you  please  share relevant screenshots to further elaborate on your question?

     

    Best Regards,
    Community Support Team _ Eason

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    AvPowerBI - Perhaps something like:

    Measure =
      VAR __Calc = <some calculation>
    RETURN
      IF(__Calc = 0,BLANK(),__Calc)

    Make sure that "Show items with no data" is not turned on anywhere. 

     

    Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

    Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, AvPowerBI 

    Could you please tell me whether your problem has been solved?

    For now, there is no content of description in the thread.

     

    Best Regards,
    Community Support Team _ Eason