Heatmap matrix from excel

[Anonymous]

Hello guys,

I'm trying to represent a heatmap matrix that I have stored in excel sheet in PBI but I'm facing some problems.
The sample matrix looks like that:

Screenshot:

Data:

Function	Main Functions
Service Portfolio / Service	Network Service	Video Service	Data Service
Region	Country	H/C	LAN	WAN	WIFI	Routing	Video	Voice	SQL	BigData
Company	Services alligned to BU	Employee count
Western	UK	4,000	1	1	1	1	1	1	1	1
PL	200	1	1	1	2	1	3	3	2
Ukraine	30	1	1	1	2	1	1	3	2
Russia	40	1	1	1	2	1	1	3	2
Netherlands	54	2	1	1	2	1	3	3	2
Belarus	61	1	1	1	2	1	1	3	2
Ireland	1,234	1	1	1	2	1	1	3	2

How would you approach that?
I was trying to model it as a list, but it requires a lot of manual work and I'm still having a problem to shape the RAG's properly.

Thanks in advance!

Best regards,
Bartek

[v-lionel-msft]

Hi @Anonymous ,

Your data table is too confusing. It is impossible to create your sample matrix diagram from your data table, so you must manually modify your data table.

Or, does your data table come from your pivot table in Excel? Don't do like this, import the original data directly  to Power BI Desktop, then, create visualization in Power BI Desktop.

In addition, it's impossible to realize your sample matrix in current version( 2.76.5678.782 64-bit (December 2019)). 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

I can't understand where the colorful part of your graph comes from. Is that more data or calculations? 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