Forum Discussion

zervino's avatar
zervino
Icon for Helper I rankHelper I
2 years ago
Solved

Matrix visual, don't show rows with empty name

I have created a matrix visual and currently looks like this:   The source data has 3 columns: Team, Block, Person and then values for years. My issue is that not all rows in the source data...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi zervino ,

     

    Thanks for the reply from ajohnso2 , please allow me to provide another insight: 

     

    According to your description, I created these data.

     

    1. Create a measure to determine whether the three-level names are all empty. If they are all empty, return 999, otherwise return the value to be displayed before.

    MEASURE = 
    IF (
        MAX ( 'Table'[Team] ) = BLANK ()
            && MAX ( 'Table'[Block] ) = BLANK ()
            && MAX ( 'Table'[Person] ) = BLANK (),
        999,
        SUM ( 'Table'[value] )
    )
    

     

    2. Filter the results where the measure is not 999 in the filter, and put the measure into the matrix values ​​position.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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