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

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

Hi Alkhos,

 

Can you share some sample data and expected data table? So that we can check whether we can achieve it in Query Editor.

 

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