Apply conditional formatting to entire table

[pat1214]

Hello,

I am trying to apply conditional formatting to the entire table to make it look like a heat map. I tried using the table heat map visual, but I need to display some measures in my category field and I was told that I cannot do so in that visual (previous post).

The suggestion was to use table visual with conditional formatting, but it looks like you can apply background color scales only on individual columns. Also I do not want to 'color based on' on any specific column.

I am attaching a snapshot of the table visual from power bi and what I would like for it to look like as a heat map. Highly appreciate any input!

[Anonymous]

Just curious if you found a way to produce this in PBI.  I am looking to do the same.

[v-yulgu-msft]

Hi @pat1214,

No. It is not availabe to make table visual to be displayed exactly the same as Heat Map. Right now, the only way is to set conditional format for each field one by one.

Best regards,

Yuliana Gu