Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |