Change how data is formatted to allow multiple columns worth of data to be visualized in one bar cha

[cmcthayer]

I have a massive patient data set that is formatted in a way that works for almost everything.  This patient data set has annonymized data from about 310,000 patients, and there are columns for multiple diseases as well as demographics for each patient.  I need to be able to visualize all "Symptoms" in one chart - but currently I have the data set up so that each symptom is it's own column.  I want this data to be able to correlate with some other columns which is why I have not just pulled the symptoms data to show in aggregate.  For example, there is an additional column with "Sex" and I want the chart to be able to be filtered by that.  Is this possible to this detail level of data?  Currently I have multiple bar charts stacked on top of each other which is fine, but it means the user cannot sort and has to just view it as I set it up (in this case alphabetically).  This data

[lbendlin · Accepted solution]

A couple of things:

Power BI visuals are limited not necessarily by the amount of data they can process, but more by the physiological limits. For example bar charts or line charts only show a maximum of 12 bars or lines even if you have many more  legend values. You will also see an "i"  icon to indicate that grouping is happening if you have "too many"  fact values.

Have a look at the decomposition tree visual, or use the Q&A visual to explore your data in a more meaningful way.