Forum Discussion
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 the axes around. As in I want the months 1 through 12 in my X axis and the dates on the Y axis. Is there a way to do this or a work around for it? Thank you!
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
4 Replies
v-piga-msftResident Rockstar
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
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
