EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials PowerBI Tutorial Power BI Heat Map
Secondary Sidebar
PowerBI Tutorial
  • Advanced
    • Power BI Tutorial
    • KPI in Power BI
    • Power BI Calendar
    • Power BI Dashboard Samples
    • Power BI DAX
    • Power BI Filter
    • Power BI Icon
    • Slicers in Power BI
    • Power BI IF Statement
    • Power BI Template
    • Power BI Maps
    • Measures in Power BI
    • Power BI Report
    • Power BI SUMX
    • Power BI Charts
    • Power BI Pie Chart
    • Power BI Bullet Chart
    • Power BI Gantt Chart
    • Power BI Bubble Chart
    • Power BI Waterfall Chart
    • Power BI Drillthrough
    • Power BI Themes
    • Power BI Tooltips
    • Power BI Heat Map
    • Creating Reports in Power BI
    • Power BI Connections
  • Basic
    • What is Microsoft Power BI
    • Is Power BI Free?
    • Power BI Visuals
    • Power BI Parameters
    • Power BI Alternatives
  • Interview Questions
    • Power Bi Interview Questions

Related Courses

Power BI Certification Course

Business Intelligence Certification Course

Data Visualization Certification Course

Power BI Heat Map

By Priya PedamkarPriya Pedamkar

Power BI Heat Map

Heat Map in Power BI

Heat map, as the name, says that it is a kind of visualization that is used when we need to project the density of data on a map for any given points. Heat Map in Power BI is the customized type of data visualization which is directly not available in the Visualization section. We all have seen in news channels when the reporter shows weather forecast they always show the area or region with different temperatures ranging from low to high with some red-yellow color contours. There is one more scenario when we see a cricket match. They always project the batsman’s scoring area in the Wagon wheel heat map. The area with the highest score is colored in dark whereas an area with the lowest score in a light color.

We will see, similar kind of Heat Map here in this article which we could implement in our regular work.

How to Use Power BI Heat Map?

To get Power BI Heat Map, first, open Power BI Desktop and login in using Sign in option.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,241 ratings)

Power BI Deskstop (Sign in)

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

We can use Corporate or Student ID only to access this feature. Once we get into the Power BI server, then click on 3 dots at the end of the Visualization section to import custom visuals. And select Import From Marketplace”.

Power BI Heat Map Example 2

This will take us to Power BI Marketplace. Search for Heat Map in the search option and select Heatmap and to get that, click on Add.

Power BI Heat Map Example 3

Upon successful import, we will get the message as shown below.

Power BI Heat Map Example 4

We will be able to see the Heat map under the visualization section then.

Power BI Heat Map Example 5

Example #1

To create a heat map, we will need data. So you can download the excel workbook from the below link which is used for this example.

You can download this Power BI Heat Map Excel Template here – Power BI Heat Map Excel Template

Now we have City name and Quantities sold in those cities as shown below.

Power BI Heat Map Example (1-2)

  • Now we will upload this data into Power BI. Click on Get Data option and select the source of the file. Here, our data is in Excel.

 Example 1-3 (Menu Ribbon)

  • Browse the file and open it. Select the sheet with the data and then click on Load.

Power BI Heat Map Example 1-4

  • Once the data is loaded then we are good to go. Next, select the Heat Map from the Visualization section as shown below.

 Example1-5 (Visualization section)

  • Now drag the required fields in Visualization. Put City name into Location ID and Quantity into Value.

Power BI Heat Map Example 1-6

  • We will then get our basic first heat map view as shown below.

Power BI Heat Map Example 1-7

  • Now, let’s change this into Heat Map. For this, go to the Format section and change the type from Contour to Heat as shown below.

Example 1-8 (Format section)

  • We will see, as we selected Heat from Renderer type the map got changed to actual Heat Map. Where we can notice that Mohali is the city with the most number of sales. And the color of Mohali got changed to Red heat.

Power BI Heat Map Example1-9

  • If we try to understand the created Heat map then we will notice on the right top header, there is a list of legends that show which city is at the high notch of selling maximum quantities at that range. This is the easiest way to understand the map by seeing the colors.

Example 1-10 (list of legends)

Example #2

When we search the heat map into the search bar of Power BI Market place, we found Table Heatmap as well. Table heat map is also a kind of Heat Map which is in the form for Table. We will add this Table heat map into our visualization with the same process.

Example 1-11 (Table Heatmap)

  • This is where Table Heatmap will be found in visualization.

Example 1-12 (visualization)

  • Open a new page for Table heat map and Select the Table Heatmap from the above list.

Power BI Heat Map Example1-13

  • Now drag the City Name and Quantity fields into Category and Y section.

Power BI Heat Map Example1-14

  • We will see, in the form of Table, all the city names and quantity sold are highlighted in the color and tabular form.

Power BI Heat Map Example1-15

If we notice, we will observe the above line where city names are mentioned are ranging from Dark red to light red color. And the second line is starting from light red shade to dark red color which indicates which color region has observed what range of sale. Darker the color, higher the sale.

  • If we want to make any changes into created Table Heat Map, then this could easily be done using the Format option available under the visualization section.

Example 1-16 (Format)

Note: Power BI Heat Map file can also be downloaded from the link below and the final output can be viewed.

You can download this Power BI Heat Map Template here – Power BI Heat Map Template

Pros of Power BI Heat Map

  • We can use Heat Map in Power BI to project any type of view where numbers or quantities are involved.
  • Heat Map is easy to create.
  • Upon further formatting above created Heat Maps, we can make them look much better.

Things to Remember

  • Heat Map only accepts numbers.
  • Choose the color in the heat map which represents the Heat or density.
  • Heat Maps in Power BI are the customized visualization that we can be accessed only from Power BI Marketplace.
  • Marketplace has various types of visualization charts that are uncommonly used. Common charts are only seen in the visualization section.

Recommended Articles

This is a guide to Power BI Heat Map. Here we discuss how to Use Power BI Heat Map along with practical examples and downloadable Power BI template. You may also look at the following articles to learn more –

  1. Use of Power BI IF Statement
  2. Power BI Calendar(Examples)
  3. Complete Guide to Power BI Tooltips
  4. Guide to Power BI Bubble Chart
  5. Using Power BI Bullet Chart
  6. Power BI Drillthrough | How to Use?
  7. Power BI Themes | How to Apply?
Popular Course in this category
Microsoft Power BI Training (6 Courses, 4 Projects)
  6 Online Courses |  4 Hands-on Projects |  45+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Power BI Heat Map Excel Template

EDUCBA

Download Power BI Heat Map Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more