Modeling in PowerBI: Connect two tables ( Building interactive resume )
I am a student learning PowerBI by myself. I am on my way to build a resume using PowerBI. My resume dataset has two tables: Skills and Projects.
Table Projects looks like this:
Table Skills currently looks like this:
Then, I met the problem that I have one skill that connects to two or more projects. I tried to add more columns in the table Skills to have more related projects ID, yet it didn't work. Can someone please advise me on this matter?
My desired outcome is that on the dashboard, whenever we choose a skill, PowerBI will show the related project(s) where I got the specific skill(s) and vice versa.