heat map
1 Topic
Create a Heat Map with a matrix with multiple variables (or comma separated values in one parameter)
Hi all, I need help with creating a heat map using the Matrix visual (if there is a better one, I'm happy to download it but I have a desktop version only). This is very simple to do in Excel but I can't quite work out how to do this in Power BI. The data is confidential so I can't add it here. But I will use a simple analogy to describe what it looks like and what I am trying to achieve. Thank you. I have a list of ~80 students (column A) from 10 schools (column B), 10 columns, with names of classes. There may be a "1" or blank value in the Class Name columns against each student (students can be enrolled in at least one class. I also have a column with a comma-separated list of classes that each student is enrolled in (non-zero value in the previous ten columns). I need to create a heat map as a matrix with school names as rows and classes as column names and the number of students from each school enrolled in these classes as values. I want the heat map to show the highest interest in class choices. Two ways I approached it, each with limitations I couldn't solve: A) If I put all ten class columns as values, I can create conditional formatting within each column but it is column specific and doesn't look across the entire data set. B) If I use the summary column (with the comma-separated classes), it sees class combos as unique values and not as a list and therefore creates additional columns of class combos. Could you please advise how to solve the issue in either A or B approach or suggest another approach? Thank you.Solved11KViews0likes7Comments