Create Multiple Heatmaps in Power BI

Hello,

I have a question regarding creation of heatmaps in Power BI.

Assume that I have a dataset with the following four columns:

date   srcLocation  dstLocation   Value

The goals is to create heatmap for each date that is seen in the data. Here are the steps that I believe should be followed, and need some reference / help on either one:

1. Slice the data based on date, i.e. create a dataset for each unique date in the dataset

2. For each slice, transform the flat data into a matrix, i.e. column names should be srcLocation and row names should be destLocation and values should appear for each pair

3. Plot a heatmap that is sliced for each of the above matrices. Ideally, user can choose a date and see its heatmap.

Are there ways to achieve 1 and 2?

For 3, is the only way to create a visual in R? or does PBI have some heatmap visuals already?

Hi Alkhos,

1. Slice the data based on date, i.e. create a dataset for each unique date in the dataset

You can open Query Editor, right click the column [date] and select Remove Duplicates. Back to the report, place [date] in a slicer visual.

2. For each slice, transform the flat data into a matrix, i.e. column names should be srcLocation and row names should be destLocation and values should appear for each pair

You can just drag a matrix visual to the report page which has slicer visual, then place [srcLocation] in Columns and [destLocation] in Rows.

3. Plot a heatmap that is sliced for each of the above matrices. Ideally, user can choose a date and see its heatmap.

There is a custom visual named Table Heatmap, you can download from Visuals Gallery.

Best Regards,
Qiuyun Yu