Aggregating data across rows

I looked at your pbix.  It is similar but different from the pics you show.  I wasn't able to match what you are showing, so it is hard to troubleshoot it.  Also, there are so many columns.  You definitely should unpivot these data and simplify your model to make your analysis/visualization easier.

Regards,

Pat