matrix
11 TopicsCreate 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.Solved11KViews0likes7CommentsSVG icons in matrix not showing up
Hi all, I need some help with my matrix. For the matrix outlined in pink, the SVG icons do not show up 😞 The column [svg_url] has values formatted like this : "data:image/svg+xml;utf8," & "<svg fill='#4E8BA1' width='800px' height='800px' viewBox='0 0 1920 1920' xmlns='http://www.w3.org/2000/svg'><path d='M213.333 960c0-167.36 56-321.707 149.44-446.4L1406.4 1557.227c-124.693 93.44-279.04 149.44-446.4 149.44-411.627 0-746.667-335.04-746.667-746.667m1493.334 0c0 167.36-56 321.707-149.44 446.4L513.6 362.773c124.693-93.44 279.04-149.44 446.4-149.44 411.627 0 746.667 335.04 746.667 746.667M960 0C429.76 0 0 429.76 0 960s429.76 960 960 960 960-429.76 960-960S1490.24 0 960 0' fill-rule='evenodd'/></svg>" The data category is set as Image URL I've had success with the matrix outlined in yellow (using http links), but wanted to use a different method for linking svg icons as I wanted fuller control over the icons' colour. I've also tested out the same values using a DAX measure [svg_url_DAX] and displaying it as a table (outlined in green), it shows up just fine, I wonder what went wrong. 😬 Link to .pbix file + svg icons : https://drive.google.com/drive/folders/1d_6_pT5TJtg5KpRC79plvzXfako83upA?usp=sharing Appreciate any help and pointers! Much thanks!Does anyone have a working example of the Customized data reduction capabilities in a matrix?
Hi all I'm trying to set this up for a matrix visual following the documentation here: Customized data reduction but I can't seem to get it to work. I've updated my project to use API 5.2 and I've updated the capabilites file with the exact code from that page but the properties don't appear in the format pane. Does anyone have an example of this working? ThanksDecimal change to Whole number not working in Matrix
Hello helpers, I have dataset orginally build as Decimal (10,2) format numbers, after i loaded to Power BI, i changed the number to Whole Number, Now the dataset shows as whole number fine, but the numbers in visuals still show 2 decimal 0s. And when i select the column, it shows as Whole number Formatting: Dataset: Display in Matrix Any suggestions please? Thank you1.1KViews0likes2CommentsHow to create a dynamic legend for matrix based on quarter selected
Hi I have a matrix visual that has % of Approved Request by Divison by Quarter. How can i make the quarter Dynamic? where it will show the current and previous 3 quarters based on the quarter that I have selected. I already have the measures for Current Quarter, and 3 quarters prior, but i am unable to make it dynamic.Table - One page report
Hello dear all, Is there someone who can help me to understand how to buid this visual bellow? The main challange here is to get data (KPI's names, department and etc) and just after, project in the colunms (monthly) the correspondent values (Being each colunm as a month) To make it a little bit harder, there are some conditional file formating rules (line by line) where each line is a KPI. Thank you in advance for any tip or idea. Best regards, João Moretti753Views0likes0CommentsHierarchy in matrix visual: blank rows
Hi everyone! I have a hierarchical tree of departments and i would like the show the processes_id in each unit like that using the matrix visual. The strings in the format xxx-yyyy are the processes id that are in each unit. It's working amost well except the blanks rows 😞 I would like to know if there is way not showing the blank rows. The option 'Show items with no data' is unchecked. In 'rows' i put the four levels and the process_id. The pbix file is here! Thanks for any help!Seeking help to recreate a table/card
Hi Community, I am trying to recreate a--very simple--scorecard for a client. This client creates a scorecard in Excel and I am attempting to recreate, verbatim, what they have created. I am struggling to find what I should use. I have tried a table, matrix and a kpi tile to no avail. Can anyone help guide me to what visual would be best to provide the below? Thank you!