How to create a side by side 100% stacked bar chart

[bobbob123]

Hi, 

I have the following simple data sets.

Data Set 1:

Data Set 2:

I'm trying to use the following data sets to create a side by side 100% stacked bar chart that shows the percentage of each category in grades 1,2,3,4,5,6.

My desired visual would look something like this for 2022.

I have my .pbix file attached here.

https://easyupload.io/c683ap

Any help/guidance is greatly appreciated. 

[lbendlin]

Your dataset tables are not in usable format. They need to be unpivoted before use. Please resubmit or provide the underlying Excel file as well.