Forum Discussion
Matrix - Use Row values to text search in another column and filter returned matrix values
Hi parry2k ,
Thank you for your response! I was finally able to figure it out, actually.
My error was in how I was thinking about the subject lookup part of the data model and trying to create a measure or column was not the right approach.
I ended up using Transform Data to make a duplicate of the course information table and then used Split Column to create a new row for each of the subjects listed on a course. This allowed me to use the new column with one subject per cell as the row value in the matrix - which then filters down the below course information and transcript information by each subject.
I'm fairly new to data modeling and Power BI and sometimes have a hard time determining when to change something in a data model vs when to write a measure vs when to use a filter on a visualization vs etc..
Super UserPowerBIPerson42 I would recommend putting sample data in excel file and expected output (which kind of you shown here) and share excel file here, you can share using one drive/google drive and we will able to help to put the solution together.
Hi parry2k ,
Thank you for your response! I was finally able to figure it out, actually.
My error was in how I was thinking about the subject lookup part of the data model and trying to create a measure or column was not the right approach.
I ended up using Transform Data to make a duplicate of the course information table and then used Split Column to create a new row for each of the subjects listed on a course. This allowed me to use the new column with one subject per cell as the row value in the matrix - which then filters down the below course information and transcript information by each subject.
I'm fairly new to data modeling and Power BI and sometimes have a hard time determining when to change something in a data model vs when to write a measure vs when to use a filter on a visualization vs etc..