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 number(table c) and in the value field we have table a's qty column, table b's qty column, table c's qty column. What is happening right now is, it is showing all of the material code under style irrespective of the value available in Table b quantity and Table c quantity. what I want is to show the rows with the values available in table a,b,and c's quantity column. and also if I apply filter value is not blank from filter pane on table b's qty and table c's qty, it shows visual has exceeded available resources. Kindly help me out in achieve the desired result, that is no such rows which don't have value in table b's qty and table c's qty.
attaching expanded matrix visual in excel for your reference.The rows highlighted in red shouldn't be there in the matrix itself 

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      Hi Mengmeng Li,

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi ritika3560 ,

         

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

         

         

        Best regards,

        Mengmeng Li