Forum Discussion

pat1214's avatar
pat1214
Frequent Visitor
8 years ago

Apply conditional formatting to entire table

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!

 

 

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

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