Help with pivoting survey data

Hello all,

I have been playing with power BI for a couple months and I have tried over and over to get this to work.  I want to make a visualization of medical comorbidities with all the column headers on the X-axis and the counts on the Y-axis.  The data is stored so that each row is one survey response and each comorbidity is it's own column with yes/no checked for each one.  I am assuming that some sort of pivot function needs to happen but when I pivot the columns I want flattened it destroys all the rest of my visualizations.  For example I can pivot the comorbidity columns but then when I go back to look at the Race graph it has thousands of entires because of all the added rows from pivoting the few columns I want changed.  Any ideas?