Power BI Qualification Report

Hello, I want to create a report by displaying the qualifications of each employee. I have the following tables: tbl_taet_anforderungsprofile:

Here are the individual qualifiers, which result in a profile. e.B. for the NETZ001 profile, the employee requires 6 different qualifications.

tbl_taet_daten_theorie:

Then there is the table with the theoretical teachings.

The date is then always the validity, until which date the training is valid.

tbl_taet_daten:

The practical activities are documented here.

The practical data is collected via a power app, the theoretical data I get via a data import. All data is in sharepoint lists.

How can I merge this data now? In the report, I would like to be able to select the respective employee and see at a glance which profiles he or she has. See the Powerapps view here:

The profiles I fill are displayed in green, the others in red. Of course, it would be nice to have a progress bar here. Can you help me here?

Greetings David