Creatinga Dynamic Performance Bin Trend Charts/Tables?

Hi Community,

I am looking into creating a dynamic trend table and chart, which will allow me to group associates into performance bins (bins are fixed) and allow me to look at weekly/monhtly trends in chart or visual.
I need it to change depending on differnt factors i add to the table (business groups).

I am aware I can probably make a measure for each bin, however As I need to do this across 20+ KPIs, I am trying to find simpler solution. 

I have added an image of what I am trying to achieve created in Excel
Any ideas? Thanks!!