Forum Discussion

Alkhos's avatar
Alkhos
Advocate I
9 years ago
Solved

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...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Alkhos,

     

    In your scenario, you can use Treemap to display values like the matrix, and place Date field within the slicer visual to filter Treemap data. See:

     

     

    Best Regards,
    Qiuyun Yu

Alkhos's avatar
Alkhos
Advocate I
9 years ago

Hi v-qiuyu-msft

 

Here is some sample data:

 

 

So I deally I want to have a heatmap ( similar to the matrix visual ) that has src for the rows and dest for the columns and average of values for all dates at the intersection points ( actually if matrix visual had conditional formatting like the table, it would have done the trick ). Then I want to have a slicer that can be used to filter (avergae) data for (a) specific day(s)

 

Bests

Ali

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Alkhos,

 

In your scenario, you can use Treemap to display values like the matrix, and place Date field within the slicer visual to filter Treemap data. See:

 

 

Best Regards,
Qiuyun Yu