topic Re: Capability profile matrix heatmap in Developer

Capability profile matrix heatmap

Anonymous — Tue, 21 Apr 2020 12:17:20 GMT

Hi,

I want to create capability profile matrix on which I could compare employee skills with requirements for some job position.

I manually created table with three columns (skill id, discipline id, and rating) which is equivalent to below table.

There are two disciplines, under each there are several skills.

Employee to meet this position requirements (above table) should be rated in the same way (1 for L, 1 for TB, 2 for M, etc.)

I want to compare profile table with employee ratings and conditionally change the color of boxes which are meeting position requirement.

I want to create matrix which will be looking like this

Red skills are this for which employye rating is the same.

I am wondering how to compare table with profile and this with employee rated skills,

Kind regards

Re: Capability profile matrix heatmap

Greg_Deckler — Tue, 21 Apr 2020 12:40:03 GMT

Conditional formatting?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Capability profile matrix heatmap

Anonymous — Tue, 21 Apr 2020 13:02:19 GMT

Yes, but how to compare these two tables, with profile and employee ratings and show it as matrix

Re: Capability profile matrix heatmap

Anonymous — Thu, 23 Apr 2020 02:00:59 GMT

Hi @Anonymous,

I think it is possible through customize and measure formula, but it requires some tricks on calculation measure formula coding and conditioner color formula measure fields.

Can you please share some dummy data with a similar data structure to test and coding formula?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Capability profile matrix heatmap

Anonymous — Thu, 23 Apr 2020 07:53:43 GMT

Hi @Anonymous ,

thank you for your message.

These are my tables:

Assessment

ID	EMP_ID	SKILL_ID	RATE
1	1	1	3
2	1	3	2

Employee:

ID	EMP_NAME	EMP_ROLE
1	Kamil Kowalski	Junior Specialist
2	Anna Nowak	Junior Specialist

Skills:

ID	SKILL_NAME	SKILL_CATEGORY
1	Python	Programming
2	SQL	Programming

And manualy created table with profiles:

ID	POSITION	SKILL_ID	RATE
1	1	1	3
2	1	3	1

Tables are connected in snowflake schema with assessment table in center.

Kind regards

Re: Capability profile matrix heatmap

Anonymous — Thu, 30 Apr 2020 08:25:01 GMT

HI @Anonymous,

I'd like to suggest you create a calculated table to extract and merge all skill category and employee roles, then you can and add a new column to configure the main category of these values.

After these steps, you can use employee id on two, new table main categories and detail value(employee role, skill type) as column write a measure to use current value(employee id and skill category) to lookup and summarize correspond rate value.

Regards,

Xiaoxin Sheng