Forum Discussion

pat1214's avatar
pat1214
Frequent Visitor
8 years ago
Solved

Interchanging axes in a table heat map

Hello!   This is my first project at work with power BI and as a preliminary step, I am creating a table heat map with my organization's data. For the table heat map, it does not allow me to flip t...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi pat1214,

     

    By my tests, it seems that we could not drag measure to category field. 

     

    If you have to use the measures of month, you could use Table visual which also have conditional formatting. 

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi pat1214,

 

It seems that you should drag the Month column to Category Field and Dates columns to Y Field.

 

You could have a view of this video about how to create table heatmap.

 

If you still need help, please share your data model then I could help you.

 

Best Regards,

Cherry

pat1214's avatar
pat1214
Frequent Visitor
8 years ago

Thank you very much for responding. I have not been able to drag the months to 'Category', as in, when I drop the field there, it doesn't do anything and that's why I ended up showing them on the Y axis, but the person who requested this prefers it to be the other way around. The months are all 'New measure', I don't know if it has anything to with that. If you need to see the data model, I can attach a snap shot of it. Appreciate any help to get this corrected.

 

Thank you!

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi pat1214,

     

    By my tests, it seems that we could not drag measure to category field. 

     

    If you have to use the measures of month, you could use Table visual which also have conditional formatting. 

     

    Best Regards,

    Cherry

    • pat1214's avatar
      pat1214
      Frequent Visitor
      8 years ago

      Thank you, that was my suspicion as well but I wanted to confirm before I scrapped the whole heat map.