Hi @Anonymous ,
I used your small data example and created a table:
Then I wrote an average measure to iterate the whole table, to scan each row of the column:
Average Score = AVERAGEX('Table', 'Table'[Score])
After that:Example 1
- I choose a table chart and dragged these two fields:
To give color to the cells, you need to do this:
Example 2 - If you want to make a bar chart, to segment each column but the category of "Overall score group", you need to do the following: Click on Stacked bar chart, place these fields as shown below with Overall score group on the Legend field.
To get rid of the Y-axis and title, choose the chart and click here:
Finally, to activate data labels and total labels, write on search "Labels" and choose the following:
Here you will fill the example if you need to explore and test 🙂 https://we.tl/t-VyK84gWXPa
Hope I was of assistance!
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂