Forum Discussion

ritika3560's avatar
ritika3560
Regular Visitor
1 year ago

Remove Unwanted rows from Matrix visual

I'm trying to display certain hierarchy in the matrix like : in matrix row field we have style(table a) followed by material code(table b) followed by purchase order((table b) followed by document nu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ritika3560 ,

 

According to your description, do you want to hide the rows where both Bqty and Cqty are empty? If I understand correctly, you can try to create a measure.

tag = IF(ISBLANK(MAX('TableB'[B qty]))&&ISBLANK(MAX(TableC[C qty])),1,0)

Then filter the measure value to 0 in the Filter and adjust the column width to hide the tag column.

 

 

 

 

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

 

Best regards,

Mengmeng Li

ritika3560's avatar
ritika3560
Regular Visitor
1 year ago

Hi Mengmeng Li,

I have tried this approach as well but no change to the matrix 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ritika3560 ,

     

    Could you please provide sample data and pbix file (exclude private data)? That will help me provide solutions.

     

     

    Best regards,

    Mengmeng Li

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ritika3560 ,

     

    I hope I'm not disturbing you, how is the situation now? Feel free to contact me.

     

     

    Best regards,

    Mengmeng Li