I have imported a dataset of my employees' competency levels from SurveyMonkey to an Excel workbook. When imported into PowerBI, the data had unnamed columns of questions and the questions were in the first row, which is where I promoted the first row to the headers. I cleaned up the data, deleted irrelevant columns, (in the excel workbook before importing, I merged across the comptency levels). Basically the data Columns are Respondent ID, Full Name, Discipline and then the hundreds of questions, some of which are interprofessional competency related questions.
I then unpivoted the other columns when selecting Respondent ID, Full Name, Discipline, this that created the questions to be in rows, and there was a values column which has the level of competency (i.e. Novice, Advanced Beginner, Proficient etc.). The questions are in this format "1.01 As an interprofessional mem", "1.02 As an interprofessional xyz" etc.
I now have to create interactive visualizations that show the trends and gaps in their competency levels. I have been asked to create a table that only contains the interprofessional questions from 1.01 to 1.06, however, I am struggling to do this. Please help and let me know if you need more information.
