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

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.