It is also sorting such names in ascending order. We can prepare coordinates per each grid 4 points (upper left, upper right, lower left, lower right) per each grid, with the color (KPI status). The idea is to show KPI per bin/grid location for example like below. This measure is concatenating all the staff names that have given performance and potential levels. Hi, I would like to draw geo grids/bins using power BI desktop.
Definition: =CONCATENATEX(‘talent mapping’, ,”, “,asc)Īdd this measure to values area of the pivot and your 9 box talent map will be ready. Right click on the table in fields list area and select “Add measure” option. We need to show the names of people instead of count in the values area. Now add “performance” to column labels and “potential” to row labels area of the pivot. Read more about data model based pivot tables. During the insert pivot step, enable “add this to data model” option, as depicted below. Insert a pivot table from your talent data. Here is a quick demo of the Pivot Table based 9 box talent map grid. Note: this method requires Excel 2013 or above versions Learn more about FILTER & SORT functions. SORT() function sorts these names in alphabetical order.įinally TEXTJOIN() is used to combine all names to one big text with comma & new line character between names. We are using FILTER() function to filter down the talent table to all candidates who have given performance (E8) and potential (D5) values The above formula assumes E$8 has the performance rating value and $D5 has potential. In the top left cell, use the below formula. Note: this method requires Excel 365 with dynamic array functions. If you have Excel 365 and access to dynamic array functions like FILTER(), you can use formulas to generate the 3×3 talent map grid.Įlse, you can use Pivot Tables to generate the talent map grid. Step 2: Create the talent map 9 box grid visual #POWER GRID MAPPING FREE#
Feel free to add things like department or team names. At the very least, you want staff name, performance and potential. In a blank spreadsheet, gather the data about your staff. Step 1: Gather data about performance and potential of your staff
0 kommentar(er)
