Team Skill Assessment

Hi all,

I hope someone could advise on my use-case as I have tried numerous options to make it.... And obviously failed...

I created table in Microsoft Lists (updates will be done here). Rows are names, columns are technical areas and values are levels of expertise in technical areas (none, basic, advanced, master). This data is taken to PowerBI, where I need to set up:

1. table/matrix showing total numbers of expertise per technical area (rows are levels of expertise, columns are tech. areas and values are total numbers)

2. filter where I choose from combination of technical area + levels of expertise

As a result, I should be able to get on-demand, how much which level of expertise we have in the team for each specific area.