Displaying Yes, No, NA values

Hi aammk,

I just create the sample file based on your case description, assume that you have similar dataset with the table testCountPro in below screenshot.    

First, translate these documents columns into attribute-value pairs

• Click Edit queries > Edit queries, navigate to Power Query Editor
• Copy the table testCountPro and paste with name “testCountPro2”, select this new table (make backup for the original table)
• Select all documents columns(Doc1~Doc7), then click “Unpivot Columns”     

Then create one calculated colum calSta：

calSta = SWITCH('testCountPro2'[Value],"Yes",1,"No",2,"NA",3)

Finally, create one matrix visual, put the related fields onto matrix as below:       

If the above method is not applicable in your scenario, please provide the related table structure and sample data.

Best Regards

Rena