Group by Column values (Count)

Hello Anonymous ,

This would be easier if you can unpivot columns in edit query,

Select columns and click Unpivot Columns option under Transform menu in edit queries, this will change your dataset in preferred format for your visualization

let me know if it helps.

Thank You,

Washivale

I believe what you need to do is unpivot your data. 

This can be achieved by using the query editor and selecting unpivot columns in the transform tab. (See below) 

After this you may need to rename some of the columns, but the when you have this done, You can throw the corresponding columns into a matrix.